Advertisement
mali_cox

zer

Jan 24th, 2017
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.20 KB | None | 0 0
  1. SELECT Korisnici.prezime, COUNT(Krediti.idKredita) AS BrojKredita   FROM (Krediti
  2. INNER JOIN Korisnici
  3. ON Krediti.idKredita=Korisnici.idKredita)
  4. GROUP BY prezime
  5. HAVING COUNT(Krediti.idKredita) > 10;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement