I am trying to create a sqlite3 database on my windows 7 64 bit machine. I have downloaded sqlite-shell-win32-x86-3071700.zip from http://www.sqlite.org/downloa
I would like to embed a SELECT inside a COUNT, but I can't find any examples. #pseudosql SELECT a AS current_a, COUNT(*) AS b, COUNT( SELECT FROM t WHERE a
I have simple example: to find all items that are sold out. Item has initialQuantity and soldQuantity integer fields. (for some reason I need initialQuantity
I have one table like CREATE TABLE table_name ( P_Id int, amount varchar(50) ) Data Like Id amount ---------- 1 2340 2 4568 3 10000 Now I want to sort t
I have a column with dates in the format 201201, 201202, 201203 etc. This is a financial database so there is a period 13; however periods 12 & 13 are comb
I have data like this: string 1: 003Preliminary Examination Plan string 2: Coordination005 string 3: Balance1000sheet The output I expect is string 1:
In SQL, I know I can do: UPDATE TableA SET MyColumn=NULL But, how do I enter NULL into a cell graphically? I tried entering 'null' and 'NULL' and '' (nothing/e
In SQL, I know I can do: UPDATE TableA SET MyColumn=NULL But, how do I enter NULL into a cell graphically? I tried entering 'null' and 'NULL' and '' (nothing/e
In SQL, I know I can do: UPDATE TableA SET MyColumn=NULL But, how do I enter NULL into a cell graphically? I tried entering 'null' and 'NULL' and '' (nothing/e
Is there an method for programmatically (in T-SQL) retrieving the maximum (and minimum) value of a datatype? That it would act like float.MaxValue in C#. I wou
Is there an method for programmatically (in T-SQL) retrieving the maximum (and minimum) value of a datatype? That it would act like float.MaxValue in C#. I wou
I have a 20-or-so column table 'Contacts' in a Contacts.sqlite file. I use the Mac Terminal to interact with it, and am writing a program tha
Is there an method for programmatically (in T-SQL) retrieving the maximum (and minimum) value of a datatype? That it would act like float.MaxValue in C#. I wou
Is there an method for programmatically (in T-SQL) retrieving the maximum (and minimum) value of a datatype? That it would act like float.MaxValue in C#. I wou
I have a 20-or-so column table 'Contacts' in a Contacts.sqlite file. I use the Mac Terminal to interact with it, and am writing a program tha
I have a 20-or-so column table 'Contacts' in a Contacts.sqlite file. I use the Mac Terminal to interact with it, and am writing a program tha