Answers for "order by multiple when columns sql"

multiple order by sql

ORDER BY column1 DESC, column2

Posted by: Guest on December-29-2020

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 "order by multiple when columns sql"