SQLServer 自定义排序

--未排序
select t1.FItemID,t1.FName from V_DataDictionary t1 where t1.FItemClass='入库类型' 

 

 

--排序之后
select t1.FItemID,t1.FName from V_DataDictionary t1 where t1.FItemClass='入库类型' 
order by t1.FItemID asc

 

 

 

--插队排序(1个)
select t1.FItemID,t1.FName from V_DataDictionary t1 where t1.FItemClass='入库类型' 
order by case when t1.FItemID='1116006' then 0 else 1 end  asc

 

--插队排序(1个以上)
select t1.FItemID,t1.FName from V_DataDictionary t1 where t1.FItemClass='入库类型' 
order by case when t1.FItemID='1116006' then 0  when t1.FItemID='1116008' then 1 else 2 end asc

 

 

 

 ------------------------------- ------------------------------- ------------------------------- ------------------------------- ------------------------------- ------------------------------- -------------------------------

--未排序
select t1.FItemID,t1.FName from V_DataDictionary t1 where t1.FItemClass='入库类型' 
--排序之后
select t1.FItemID,t1.FName from V_DataDictionary t1 where t1.FItemClass='入库类型' 
order by t1.FItemID asc
--插队排序(1个)
select t1.FItemID,t1.FName from V_DataDictionary t1 where t1.FItemClass='入库类型' 
order by case when t1.FItemID='1116006' then 0 else 1 end  asc
--插队排序(1个以上)
select t1.FItemID,t1.FName from V_DataDictionary t1 where t1.FItemClass='入库类型' 
order by case when t1.FItemID='1116006' then 0  when t1.FItemID='1116008' then 1 else 2 end asc