Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT COUNT(o.Ocena) liczbaOcen, o.IdPrzedmiot, p.Katedra
- FROM A1_OCENA o
- INNER JOIN A1_PRZEDMIOT p ON o.IdPrzedmiot=p.IDPRZEDMIOT
- GROUP BY o.IdPrzedmiot, p.Katedra
- HAVING COUNT(o.Ocena) = MAX(liczbaOcen)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement