As an interesting challenge, see if you can figure out how to sort the orders by shipped date ascending, but have NULLs sort last. (Hint: You can specify expressions in the ORDER BY clause; think of how to use the CASE expression to achieve this task.)
- 3. Filtering and Sorting Data
- from Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012
- Publisher: Microsoft Press
- Released: December 2012
Could include ORDER BY COALESCE(col1,'ZZZZZZZ') as an example.
Share this highlighthttp://www.safaribooksonline.com/a/training-kit-exam/57944/