Answers for "t-sql case order by multiple field and direction separately"

SQL
0

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
Posted by: Guest on October-07-2020

Code answers related to "t-sql case order by multiple field and direction separately"

Code answers related to "SQL"

Browse Popular Code Answers by Language