SELECT COUNT(*) as tekrar, * FROM table_name GROUP BY somevaluecolumn ORDER BY tekrar DESC