Na koji nacin mogu izdvojiti slog iz baze koji se najvise ponavlja

[ abcd @ 02.11.2006. 11:25 ] @

[ mika @ 02.11.2006. 12:14 ] @

Na primer ovako (ugnjezdeni upit mora da se koristi):

Code:

SELECT MAX(CntData)
FROM
   (SELECT Data, COUNT(Data) AS CntData
   FROM Table
   GROUP BY Data)

[ zikaa @ 05.11.2006. 15:12 ] @

Evo i resenje bez ugnjezdenog upita

Code:

SELECT slog, COUNT(slog) AS cnt
FROM table
GROUP BY slog
ORDER BY cnt DESC
LIMIT 1