This is to PRINT, from dbo.Emp, the total number of records, per unique value
I did it this way: SELECT field1, COUNT() records FROM dbo.Emp GROUP BY field1 HAVING SUM()
Asked
Active
Viewed 328 times
0
-
Alright. So, would that PRINT the total number per 'unique' or distinct value? Something like COUNT(Distinct)records or COUNT (SUM of distinct)records – PureData1 Oct 29 '14 at 03:25
-
If you want distinct use count( distinct field1) – radar Oct 29 '14 at 03:26
-
AH...YES! THANK YOU Radar So: SELECT COUNT(Distinct field1) records FROM Emp GROUP BY field1 – PureData1 Oct 29 '14 at 03:28