t sql conditional order by multiple columns

Solutions on MaxInterview for t sql conditional order by multiple columns by the best coders in the world

Search
showing results for - "t sql conditional order by multiple columns"
Valerio
29 Sep 2019
1SELECT * FROM dbo.Employee
2ORDER BY 
3 CASE WHEN Gender='Male' THEN EmployeeName END Desc,
4 CASE WHEN Gender='Female' THEN Country END ASC
similar questions
multiple order by sqlsql server conditional where clausesql several orupdate multiple columns in sqlsql select two columnssql query with multiple where conditionssql server check for value in multiple columnswhere sql multiple conditionssql query orderby two or more columns and by number of characterssql case when multiple conditionssql order by multiple columnssql select from multiple tables with conditionsmultiple where condition in sqlsort order on two columns sqlmysql order by multiple columnssql query update multiple columnssql update multiple columns from another tableorder by with more than one columnsql order by two columnsselecting multiple columns in sqlsql two conditionsupdate query for multiple columnsorder by multiple columns
queries leading to this page
t sql conditional order by multiple columnssql multiple or conditions order byt sql case order by field and direction separatelysort in sql with case statement two columnsorder by sql with two columns where conditionmultiple orderby clause sql server casesql order by multiple columnst sql case order by multiple field and direction separatelycase order by sql multiple columnssql server order by case when multiple columnsif we use order by in sql for several columnsorder by multiple when columns sqlorder by with case columnst sql conditional order by multiple columns