Advertisement
Guest User

Untitled

a guest
Jun 28th, 2017
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.51 KB | None | 0 0
  1. select imię, nazwisko, p1.KrajOdbiorcy from
  2. (select count(IDzamówienia) as ile, IDPracownika, KrajOdbiorcy
  3. from Zamówienia as z
  4. group by IDpracownika, KrajOdbiorcy) as p1
  5. join
  6. (
  7. select max(ile) as ile, KrajOdbiorcy from
  8. (
  9. select count(IDzamówienia) as ile, IDPracownika, KrajOdbiorcy
  10. from Zamówienia as z
  11. group by IDpracownika, KrajOdbiorcy
  12. ) as t1
  13. group by KrajOdbiorcy
  14. ) as t2
  15. on p1.KrajOdbiorcy = t2.KrajOdbiorcy
  16. join pracownicy p on p.IDpracownika = p1.IDpracownika
  17. where p1.ile = t2.ile
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement