将带有"非限定性"的数据的字段放在最前面, 其余数据另排序
方法一:
select
case when zjly like '%非限定性%' then 0 else 1 end as num
from X
order by num
方法二:
select * from X
order by Case When PATINDEX('%[非限定性]%',zjly)>0 Then 0 Else 1 End
将带有"非限定性"的数据的字段放在最前面, 其余数据另排序
方法一:
select
case when zjly like '%非限定性%' then 0 else 1 end as num
from X
order by num
方法二:
select * from X
order by Case When PATINDEX('%[非限定性]%',zjly)>0 Then 0 Else 1 End