in reply to searching items in a row based on time and date
Even a spreadsheet can do it.CREATE TABLE foobar ( Who CHAR(1), When DATETIME); ... INSERT INTO foobar ... INSERT INTO foobar ... ... SELECT Who, COUNT(DISTINCT who) FROM foobar GROUP BY who; ...
|
|---|