sql server order by case when multiple columns code example
Example: t-sql conditional order by multiple columns
SELECT * FROM dbo.Employee
ORDER BY
CASE WHEN Gender='Male' THEN EmployeeName END Desc,
CASE WHEN Gender='Female' THEN Country END ASC