Advertisement
Guest User

utery_variantaA_2

a guest
Oct 21st, 2014
386
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.47 KB | None | 0 0
  1. SELECT uID, jmeno,
  2. (
  3.     SELECT COUNT(*)
  4.     FROM
  5.     (
  6.         SELECT TOP 1 oID
  7.         FROM objednavka ob
  8.         WHERE ob.uID = o.uID
  9.         ORDER BY ob.vytvorena DESC
  10.     ) ob
  11.     JOIN polozka p ON ob.oID = p.oID
  12. ) pocetPolozek
  13. FROM osoba o
  14.  
  15.  
  16. SELECT o.uID, o.jmeno, COUNT(*) pocetPolozek
  17. FROM osoba o
  18. JOIN objednavka ob ON o.uID = ob.uID
  19. JOIN polozka p ON ob.oID = p.oID
  20. WHERE ob.vytvorena >= ALL
  21. (
  22.     SELECT vytvorena
  23.     FROM objednavka ob2
  24.     WHERE ob2.uID = o.uID
  25. )
  26. GROUP BY o.uID, o.jmeno
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement