Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --1
- SELECT Naimenovanie, Cenanaizrabotka FROM Artikuli ORDER BY Cenamateriali DESC
- --2
- SELECT e.Ime, d.Imenashivach, d.Artikul, d.Broy, f.Cenamateriali
- FROM Zarabotki AS d
- JOIN Artikuli AS f
- CROSS JOIN Shivachi AS e
- ON (f.Cenamateriali = f.Cenamateriali AND f.Cenamateriali >5)
- ORDER BY Cenamateriali
- --3
- SELECT e.Ime, e.DataNaZarabotka, d.Artikul, d.Broy, f.Cenanaizrabotka
- FROM Zarabotki AS d
- JOIN Artikuli AS f
- JOIN Shivachi AS e ON d.Naimenovanie = e.Ime
- WHERE d.Naimenovanie = 'Pola' OR d.Naimenovanie= 'Pantalon'
- ORDER BY Cenamateriali
- --4
- SELECT e.Ime, e.Telefon, d.Artikul, d.DataNaZarabotka, f.Artikul, f.Broy
- FROM Zarabotki AS d
- JOIN Artikuli AS f
- JOIN Shivachi AS e
- WHERE lastname LIKE 'D%'
- ORDER BY Ime
- --5
- SELECT е.Ime, f.Artikul, d.Broi, Cena, d.DataNaZarabotka
- FROM Zarabotki AS d
- JOIN Artikuli AS f
- CROSS JOIN Shivachi AS e
- WHERE d.Zarabotki>100
- ORDER BY Zarabotki
Advertisement
Add Comment
Please, Sign In to add comment