Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- 1. způsob
- select nazev
- from Výrobce
- where exists
- (
- select nazev,kategorie,cena
- from Hra
- where kategorie like 'fps' and Výrobce_ičo = ičo
- intersect
- select nazev,kategorie,cena
- from Hra
- where cena < 1000
- )
- -- 2. způsob
- select nazev
- from Výrobce
- where ičo in
- (
- select Výrobce_ičo
- from Hra
- where nazev in
- (
- select nazev from Hra
- where kategorie like 'fps'
- except
- select nazev
- from Hra
- where cena > 1000
- )
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement