Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 3
- 1)SELECT * FROM `auta` WHERE marka='Ford'
- 2)SELECT * FROM `auta` WHERE idauta BETWEEN 2 AND 4
- 3)SELECT * FROM `klienci` WHERE miasto='Katowice' AND adres='%Rolna%'
- 4)SELECT marka,model FROM auta ORDER BY ubezpieczenie DESC LIMIT 1
- 5)SELECT marka,model FROM auta WHERE idauta IN (SELECT idauta FROM wypozyczenia ORDER BY datawyp ASC) LIMIT 1
- 6)SELECT imie,nazwisko FROM klienci WHERE idklienta IN (SELECT idklienta FROM wypozyczenia WHERE idauta ='1')
- 7)SELECT marka,model FROM auta WHERE idauta IN (SELECT idauta FROM wypozyczenia WHERE idklienta IN( SELECT idklienta FROM klienci WHERE nazwisko = 'Pastewniak') )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement