Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT uID, jmeno,
- (
- SELECT COUNT(*)
- FROM
- (
- SELECT TOP 1 oID
- FROM objednavka ob
- WHERE ob.uID = o.uID
- ORDER BY ob.vytvorena DESC
- ) ob
- JOIN polozka p ON ob.oID = p.oID
- ) pocetPolozek
- FROM osoba o
- SELECT o.uID, o.jmeno, COUNT(*) pocetPolozek
- FROM osoba o
- JOIN objednavka ob ON o.uID = ob.uID
- JOIN polozka p ON ob.oID = p.oID
- WHERE ob.vytvorena >= ALL
- (
- SELECT vytvorena
- FROM objednavka ob2
- WHERE ob2.uID = o.uID
- )
- GROUP BY o.uID, o.jmeno
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement