mitko2204

Query for Ex.

Dec 13th, 2021
3,254
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.93 KB | None | 0 0
  1. --1
  2. SELECT Naimenovanie, Cenanaizrabotka FROM Artikuli ORDER BY Cenamateriali DESC
  3.  
  4.  
  5. --2
  6. SELECT e.Ime, d.Imenashivach, d.Artikul, d.Broy, f.Cenamateriali
  7. FROM Zarabotki AS d
  8. JOIN Artikuli AS f
  9. CROSS JOIN  Shivachi AS e
  10.       ON (f.Cenamateriali = f.Cenamateriali AND f.Cenamateriali >5)
  11. ORDER BY Cenamateriali
  12.  
  13. --3
  14. SELECT e.Ime, e.DataNaZarabotka, d.Artikul, d.Broy, f.Cenanaizrabotka
  15. FROM Zarabotki AS d
  16. JOIN Artikuli AS f
  17. JOIN  Shivachi AS e ON d.Naimenovanie = e.Ime
  18. WHERE d.Naimenovanie = 'Pola' OR d.Naimenovanie= 'Pantalon'
  19. ORDER BY Cenamateriali
  20.  
  21. --4
  22. SELECT e.Ime, e.Telefon, d.Artikul, d.DataNaZarabotka, f.Artikul, f.Broy
  23. FROM Zarabotki AS d
  24. JOIN Artikuli AS f
  25. JOIN  Shivachi AS e
  26.       WHERE lastname LIKE 'D%'
  27. ORDER BY Ime
  28.  
  29. --5
  30. SELECT е.Ime, f.Artikul, d.Broi, Cena, d.DataNaZarabotka
  31. FROM Zarabotki AS d
  32. JOIN Artikuli AS f
  33. CROSS JOIN  Shivachi AS e
  34. WHERE d.Zarabotki>100
  35. ORDER BY Zarabotki
Advertisement
Add Comment
Please, Sign In to add comment