SQL Server 指定字段自定义排序的实现

SQL Server 指定字段自定义排序的实现

https://blog.csdn.net/qq_41080850/article/details/94559079

方法一：利用order by+case when

select app.DepartmentCode,app.DepartmentName,app.PoliceNumber,app.PoliceName,app.ContactNumber,p.Photo,app.JobTitle,
case when app.JobTitle='总队长' then 4 
     when app.JobTitle='总副队' then 3 
     when app.JobTitle='队长' then 2 
     when app.JobTitle='副队长' then 1 end as JobTitleFlag, p.PoliceType from ActivityPlanPoliceDetail app,Police p  where app.PoliceNumber = p.PoliceNumber and  app.IsDeleted = 0 and app.DepartmentName='公安局刑侦支队' and app.PlanCode='ActivityPlan20201230055341' order by JobTitleFlag desc