Need a unique gift idea?
A Pastebin account makes a great Christmas gift
SHARE
TWEET

Untitled

a guest Sep 20th, 2018 75 Never
Upgrade to PRO!
ENDING IN00days00hours00mins00secs
 
  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