Code: Select all
ID | KAT
1 1
2 3
3 3
4 2
5 2
6 2
7 1
8 1Code: Select all
SELECT COUNT(id), id, kat
FROM `table` GROUP BY kat
ORDER BY RAND()Code: Select all
kat, COUNT(id), id
1 , 3 , 1
2 , 3 , 4
3 , 2 , 2