1 odgovor na temo

[boss-tech]

Imam eno povpraševanje, vendar ne vem kako potem iz teh rezultatov potegnit max:

select count(1) as cnt, id from zbirka
group by id

tukaj dobim seznam vseh IDjev(niso unique)- število pojavitev ter ID.
Npr:
cnt|ID
1 1
1 2
1 5
2 3

Kako bi sedaj dobil ven samo ID od cnt 2(se pravi max)? Ker potem pa moram naredit še poizvedbo v drugo tabelo.

[xfirestorm]

select max(cnt) as max from
(
select count(1) as cnt, id from temp group by id
) a

če hočeš zraven še id:
select id, count(id) as max
from temp
group by id
having count(id) =
( select max(cnt) from
( select id, count(id) cnt
from temp
group by id
) a
)