Hi, 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; -- ˙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