daily pastebin goal
11%
SHARE
TWEET

Untitled

a guest May 17th, 2018 107 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. //1
  2. SELECT BusinessEntityID,PersonType,FirstName,LastName
  3. FROM Person.Person;
  4. //2
  5. SELECT FirstName,LastName
  6. FROM Person.Person
  7. WHERE FirstName ='Adam'
  8. ORDER BY LastName ASC;
  9. //3
  10. SELECT ProductID, Name, ProductNumber, ListPrice
  11. FROM Production.Product
  12. WHERE Color ='Red'
  13. ORDER BY ListPrice DESC;
  14. //4
  15. SELECT ProductID, Name, ProductNumber, ListPrice, Size
  16. FROM Production.Product
  17. WHERE Size ='M';
  18. //5
  19. SELECT BusinessEntityID,Name,SalesPersonID
  20. FROM Sales.Store
  21. WHERE SalesPersonID IN (275,276,277);
  22. //6
  23. SELECT *
  24. FROM Sales.SalesOrderDetail
  25. WHERE SalesOrderID BETWEEN 69000 AND 70000;
  26. //7
  27. SELECT *
  28. FROM HumanResources.Employee
  29. WHERE JobTitle LIKE '% Specialist';
  30. //8
  31. SELECT *
  32. FROM Purchasing.Vendor
  33. WHERE PurchasingWebServiceURL IS NOT NULL;
  34. //9
  35. SELECT *
  36. FROM Production.Product
  37. WHERE Class IS NULL;
  38. //10
  39. SELECT *
  40. FROM Sales.SalesOrderHeader
  41. WHERE (
  42. TerritoryID = 9
  43. AND
  44. Year(OrderDate) = 2014
  45. );
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