Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT TOP 50 Name,CONVERT(DATE,START,102) AS START FROM Games
- WHERE YEAR(CONVERT(datetime,START,103)) IN(2011,2012)
- ORDER BY START,Name
- // горната заявка не минава долната не локално дават еднакви резултати зад 12 от build IN functions homework
- SELECT TOP 50 Name, FORMAT(START,'yyyy-MM-dd') AS [START DATE]
- FROM Games
- WHERE (SELECT YEAR(START)) IN (2011,2012)
- ORDER BY [START DATE], Name
Advertisement
Add Comment
Please, Sign In to add comment