u6_0

SELECT MAX(pocetroli) AS pocetroli
FROM
(
    SELECT
        idFilm,
        idHerec,
        COUNT(*) AS pocetRoli
    FROM postava
    GROUP BY
        idFilm,
        idHerec
    HAVING pocetRoli > 1
) AS pocetroli