Aliendreamer

dilema sql homework

May 31st, 2018
159
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.46 KB | None | 0 0
  1. SELECT TOP 50 Name,CONVERT(DATE,START,102) AS START  FROM Games
  2. WHERE  YEAR(CONVERT(datetime,START,103)) IN(2011,2012)
  3. ORDER BY START,Name
  4.  
  5. // горната заявка не минава долната не локално дават еднакви резултати зад 12 от build IN functions homework
  6.  
  7. SELECT TOP 50 Name, FORMAT(START,'yyyy-MM-dd') AS [START DATE]
  8.   FROM Games
  9.  WHERE (SELECT YEAR(START)) IN (2011,2012)
  10.  ORDER BY [START DATE], Name
Advertisement
Add Comment
Please, Sign In to add comment