SQL Server complex ordering (order by case)

/*
Table Sysid Self-increment primary key SCRO score Oper operation time SCRO score > 5 According to the fractional descending, the score is less than or equal to 5 according to the operation time Ascending; >5 in front of the =5.
*/select * FROM Test order by case-SCRO > 5 then 1 else 0 End desc, case-scro > 5 then scro elsedatediff (M Inute,oper,getdate ()) End desc--The first case put "5 and" =5 Whole, sort, the second one in order to satisfy (the score is less than or equal to 5 in accordance with the operation time Ascending) condition cannot be the same level of an ascending one descending, so by DATED The "descending" way of the IFF (Minute,oper,getdate ()), which implements the ascending order of the dates.

SQL Server complex ordering (order by case)