max count query

[chester31]

buna am query ul asta :

select max(maxim) from
(
SELECT idactor , count(idactor) AS maxim
FROM inter
group by idactor
)
am in tabelul inter :
idactor
1
2
2
2
5
5
6
vreau sa mi afiseze maximul count ului (id actor) . cum asta ??? THX

[chester31]

am incercat si asa :
select max(idactor) from inter where
(
SELECT count(idactor)
FROM inter
group by idactor
)
si nimic, imi da eroare

[ViezuREX]