I have a table messages in which something is put every minute. The total messages that are added today I can get with: SELECT COUNT(*) AS Total FROM messages WHERE date = DATE('now')
And the number of messages that where entered today, but not at the start of a minute I can get with: SELECT COUNT(*) AS Late FROM messages WHERE date = DATE('now') AND time NOT LIKE '%:00' Is there a way to get this information in one query? -- Cecil Westerhof _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users