On 18 Jun 2014, at 7:01am, David M. Cotter <d...@kjams.com> 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. You can retrieve the values, and then find a that row with that value that has the lowest rowid, but that's your own interpretation of 'first'. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users