Na koji nacin mogu izdvojiti slog iz baze koji se najvise ponavlja
Na koji nacin mogu izdvojiti slog iz baze koji se najvise ponavlja
Zaključano
Zakačeno
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)
SELECT MAX(CntData)
FROM
(SELECT Data, COUNT(Data) AS CntData
FROM Table
GROUP BY Data)
Potpis
Bolje 100 godina biti milioner nego nedelju dana siromašak
(c) Alan ford
(c) Alan ford
Evo i resenje bez ugnjezdenog upita
Code:
SELECT slog, COUNT(slog) AS cnt
FROM table
GROUP BY slog
ORDER BY cnt DESC
LIMIT 1
SELECT slog, COUNT(slog) AS cnt
FROM table
GROUP BY slog
ORDER BY cnt DESC
LIMIT 1