2011/10/16 Petite Abeille <[email protected]>: > On Oct 16, 2011, at 10:39 PM, Kit wrote: >>> select count(*) from (select 1 from table limit 5000) >> SELECT count(1) FROM (SELECT 1 FROM table LIMIT 5000); > > you realize that count( * ) has a very specific meaning, right? > "The count(*) function (with no arguments) returns the total number of rows > in the group." > http://www.sqlite.org/lang_aggfunc.html > If this is what you mean, then stick to it :)
I originally thought that the symbol "*" means "all columns". I tried to "EXPLAIN", now I see it differently. Thank you. -- Kit _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
