On Wed, Oct 29, 2014 at 8:43 PM, Richard Hipp <d...@sqlite.org> wrote:
> > If I have a table, "t", with 2 columns, "a" and "b". Assuming that "a" > is a > > unique number, will the following query always return the whole row (that > > is, with the correct "b" column) where "a" is the highest number below > 50? > > > > SELECT max(a), b FROM t WHERE a<50; > > > That is what it is suppose to do, yes. > Is there some way to filter *after* this is applied? For example, say in the above query I only want the rows where "b" is not null (side question: What is the difference between "ISNULL" \ "NOTNULL" and "IS NULL" \ "IS NOT NULL"?). So for this data: a | b --+-- 30|10 40|NULL I will get no results, but for a | b --+-- 30|NULL 40|10 I will get 40|10 -- ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
