Here in this article I am going to explain how to use CASE statement in Order by clause to sort records as per requirement.
Read this post on webcodeexpert.com