Forums
This topic is locked
fnd distinct then count records
Posted 25 Jun 2007 19:49:03
1
has voted
25 Jun 2007 19:49:03 Simon Bloodworth posted:
HiWhat im trying to do is find all the distinct values in my table then count how many there are? How can this be done?
regards
simon
Replies
Replied 30 Jun 2007 14:02:32
30 Jun 2007 14:02:32 Seb Adlington replied:
do a bit of sql with the group and count methods
SELECT COUNT(ColumnName)
FROM MyTable
Group by ColumnName
SELECT COUNT(ColumnName)
FROM MyTable
Group by ColumnName