Re: [sqlite] Help forming query

> SELECT DISTINCT column FROM table WHERE column not NULL; this is exactly what I needed, thanks! ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Help forming query

On 18 Jun 2014, at 7:01am, David M. Cotter wrote: > also: if this query isn't *very* fast, then i'm fine with just "give me the > value of the first cell where there is data in that column" SQL does not have a concept of 'first' row. Rows in a table do not have any order.

Re: [sqlite] Help forming query

On Jun 17, 2014, at 11:01 PM, David M. Cotter wrote: > also: if this query isn't *very* fast, then i'm fine with just "give me the > value of the first cell where there is data in that column" > > in the below case, i'd get a "1". > i would then proceed to delete everything

Re: [sqlite] Help forming query

On 18/06/2014, at 5:54 pm, David M. Cotter wrote: > i have a table with a numeric column (not the key column) > i want to obtain from this table a list of unique numbers appearing in that > one column > > some cells in the column may have nothing, some may have duplicate

Re: [sqlite] Help forming query

also: if this query isn't *very* fast, then i'm fine with just "give me the value of the first cell where there is data in that column" in the below case, i'd get a "1". i would then proceed to delete everything with a "1" in it (from this and other tables) then i'd ask again, this time i'd

[sqlite] Help forming query

i have a table with a numeric column (not the key column) i want to obtain from this table a list of unique numbers appearing in that one column some cells in the column may have nothing, some may have duplicate numbers eg: > 1 > 1 > 1 > 4 > _ > _ > 4 > _ note that "_" means "no data". i want