[sqlite] Get data in one query

[Cecil Westerhof]

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