I want to know the number of teas I have in stock. For this I use: SELECT COUNT(Tea) FROM teaInStock
Tea cannot be NULL, so this is the same as: SELECT COUNT(*) FROM teaInStock But I find the first more clear. I almost always see the second variant. Is this because it is more efficient, or are people just ‘lazy’? -- Cecil Westerhof _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
