daily pastebin goal
61%
SHARE
TWEET

Untitled

a guest Sep 20th, 2018 74 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. //NUMBER 1
  2. SELECT  ProductCode   AS code,
  3.         ProductName   AS name,
  4.         ListPrice     AS price,
  5.         DiscountPrice
  6. FROM tblProducts
  7. ORDER BY price;
  8.  
  9. //NUMBER 2
  10. SELECT  CONCAT(LastName, ',', FirstName) AS FullName
  11. FROM Customers
  12. WHERE FullName >= 'm'
  13. ORDER BY FullName;
  14.  
  15. //NUMBER 3
  16. SELECT ProductName AS Name,
  17.         ListPrice AS Price,
  18.         DateAdded AS DateAdded
  19. FROM tblProducts
  20. WHERE Price > 500 AND Price < 2000
  21. ORDER BY DateAdded DECS
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top