DISTINCT Count

[Siisl Oasi]

Hallo Juri, hallo Liste,

select count(*)
from tbl
group by col_1, col_2, col_3
having count(*)>1;

select distinct col_1
from tbl
group by col_1
having count(*)>1;


-- 
Salute,
 Siisl


---
*** Weitere Infos zur Mailingliste und MySQL unter http://www.4t2.com/mysql