Advertisement
Guest User

Untitled

a guest
Jun 21st, 2018
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.28 KB | None | 0 0
  1. SELECT * MyTable WHERE uid=’Медиф′;
  2. ..2
  3. SELECT *  FROM MyaART WHERE yearArt > 2010;
  4. ..3
  5. SELECT id_tovar,kilkist,name, author
  6. FROM
  7. (
  8.   SELECT TOP 3 id_tovar, SUM(kilkist) AS kilkist
  9.   FROM MyaART
  10.   GROUP BY id_tovar
  11.   ORDER BY SUM(kilkist) DESC
  12. ) ss
  13. ORDER BY kilkist
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement