SQL query to obtain a count of how many items have each possible value for a given column

SELECT STRFTIME('%H', DATETIME(time, 'unixepoch', 'localtime')), 
COUNT(anotherField)
FROM log
GROUP BY STRFTIME('%H', DATETIME(time, 'unixepoch', 'localtime'));

SELECT STRFTIME('%H', DATETIME(time, 'unixepoch', 'localtime')),

COUNT(anotherField)

FROM log

GROUP BY STRFTIME('%H', DATETIME(time, 'unixepoch', 'localtime'));

Note: I haven’t worked with SQLite. However, it supports GROUP BY and hence, this should work.

source:http://stackoverflow.com/questions/3795418/sql-query-to-obtain-a-count-of-how-many-items-have-each-possible-value-for-a-giv

发表回复 取消回复

发表回复取消回复