Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select Z.id_zamestnanca, Z.meno, Z.priezvisko from Zamestnanec as Z
- join Faktúra as F on (Z.id_zamestnanca = F.id_zamestnanca)
- group by Z.id_zamestnanca, Z.meno, Z.priezvisko
- having COUNT(F.id_zamestnanca) > select COUNT(Za.id_zamestnanca) from Zamestnanec as Za
- join Faktúra as Fa on (Za.id_zamestnanca = Fa.id_zamestnanca) where (Za.id_zamestnanca = 'JAP003')
Advertisement
Add Comment
Please, Sign In to add comment