Searching for sql (all)

Postgresql : how can i get desired output as described below

SQL	https://codedump.io/share/sVPFCTd3MkWi

I have a table named Box : Box contains the following items : 1. pen 2. pencil 3. scale 4. eraser 5. sharpener The actual table structure look...

5 years ago

Time type column field data update in mysql

SQL	https://codedump.io/share/JUGPFnf3MPsL

I have a time type column in database and i want to update current stored value. I wrote this query but data is not changed. UPDATE testing SET timev...

5 years ago

MySQL Database in XAMPP is stopped

SQL	https://codedump.io/share/6k8w20ZjLe3w

I'm running Xampp on Linux(Ubuntu 14.04) and while everything was working fine until an hour back right after I shut it down it suddenly starts throwi...

5 years ago

Access SQL Calculation in SELECT make not null

SQL	https://codedump.io/share/oGuTJkztWvlo

I have a query that filters results for products which have had orders sent after an user-input date, and calculates what the quantity becomes if the ...

5 years ago

SQL Foreign Key command won't execute

SQL	https://codedump.io/share/m4AD5hH9sB4E

when trying to execute a SQL statement that will assign foreign keys to my database I receive an error, am I missing something simple? CREATE TABLE `...

5 years ago

Sorting a column with numbers, strings and nils

SQL	https://codedump.io/share/3PmcUYXG9Ug

I have a column that includes numbers (as strings), strings and nils. I would like to order all numbers by numerical values, then strings alphabetical...

5 years ago

PostgreSQL one to many pivot with crosstab

SQL	https://codedump.io/share/sG59ohogWcpi

I am trying to build a one to many query in PostgreSQL that looks at a customer table, a transaction table and the result is a table showing which pro...

5 years ago

Getting grand totals with grouping sets

SQL	https://codedump.io/share/R2LETFhdRjIh

I am migrating SQL SERVER 2005 to SQL SERVER 2014 and came across this problem. I have a "search engine" STORED PROCEDURE that builds report queries o...

5 years ago

Show the sql Django is running?

SQL	https://codedump.io/share/xooH9ag9j6o4

Is there a way to show the SQL that Django is running while performing a query?

5 years ago

Error when posting data into SQL database from form

SQL	https://codedump.io/share/ZEII7FtYecGw

I'm trying to post data into an SQL database from a form. I really don't understand what I am missing... I tried several things I managed to make it ...

5 years ago

Show last update date

SQL	https://codedump.io/share/sJwqkr6VQaVG

I am new in this forum and also new in SQL my question is I have an Excel sheet link to database with "From Microsoft query" I have 3 tables link tog...

5 years ago

SQL Select statement not returning desired columns

SQL	https://codedump.io/share/U6HDA6wcHTmU

I have a table (sample) with 10 rows, that has columns of place_name, 5 days worth of data (day1, day2,...,day5) for each location, and a sum column (...

5 years ago

list of states with the total number of units that have been sold to that state

SQL	https://codedump.io/share/XMol0kDpwJ7u

I am still new to SQL, and have to complete the tasks at hand. The task is: A "fake" user has made a few orders. DELETE the user account along with al...

5 years ago

How to use union of two queries in SQL that has order by and count()

SQL	https://codedump.io/share/ckZkXXrZoSwU

I have following two queries how do i use union so as to see both the results in the single query execution select TOP 1 AGE, DIAGNOSIS_CODE_1, count...

5 years ago

Mysql Invalid datetime format: 1292 Incorrect datetime value

SQL	https://codedump.io/share/uH6OOrGYcQXx

5 years ago

Complexed Query - Sort by newest with average of 2 other values

SQL	https://codedump.io/share/zHcN31Sgezj

I'm trying to sort by date and average likes/dislikes. Picture #1: 5 likes, 2 dislikes, created 1 week ago Picture #2: 5 likes, 2 dislikes, created ...

5 years ago

Access denied while running Mysql for the first time on Centos

SQL	https://codedump.io/share/Ta2A9vgPNt2

I just installed Mysql for the first time on a CentOS machine using yum. The installation had no errors. Then I followed those steps: $ sudo /sbin/se...

5 years ago

SQL SELECT LIKE (Insensitive casing)

SQL	https://codedump.io/share/dfTlKWGF3uH1

I am trying to execute the sql query: select * from table where column like '%value%'; But the data is saved as 'Value' ( V is capital ). When I e...

5 years ago

Get a single row from multiple rows of a single table

SQL	https://codedump.io/share/1MkxRW1MAgxY

I have a table as given below. Here some data also added. CREATE TABLE [dbo].[ApplicationState]( [ID] [varchar](8) NULL, [S...

5 years ago

Persistent "unique constraint violation" on an empty table while inserting

SQL	https://codedump.io/share/HrAEgTzgCahm

Let's assume I'm managing a simple table. Additionally, each user can indirectly create a copy of each row and modify it on their own. Here's my setu...

5 years ago

Postgresql : how can i get desired output as described below

Time type column field data update in mysql

MySQL Database in XAMPP is stopped

Access SQL Calculation in SELECT make not null

SQL Foreign Key command won't execute

Sorting a column with numbers, strings and nils

PostgreSQL one to many pivot with crosstab

Getting grand totals with grouping sets

Show the sql Django is running?

Error when posting data into SQL database from form

Show last update date

SQL Select statement not returning desired columns

list of states with the total number of units that have been sold to that state

How to use union of two queries in SQL that has order by and count()

Mysql Invalid datetime format: 1292 Incorrect datetime value

Complexed Query - Sort by newest with average of 2 other values

Access denied while running Mysql for the first time on Centos

SQL SELECT LIKE (Insensitive casing)

Get a single row from multiple rows of a single table

Persistent "unique constraint violation" on an empty table while inserting

Latest codedumps