sql query get specific data
Hi there!
my problem is how can i count a specific data in a column?
ex:
|Column1|
V
V
O
V
i want to get the count of "V" and "O" which gives me V = 3 and O = 1
how can i achieve this? thanks!
Jef
May 30th, 2012 3:03am
Hello Jef,
With a group on column1 and a count function:
SELECT Column1, COUNT(*) AS Cnt
FROM YourTable
GROUP BY Column1
Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich tglich
Blog
Xing
Free Windows Admin Tool Kit Click here and download it now
May 30th, 2012 3:18am
thank you very much!
May 30th, 2012 3:48am