第一种方式:
select * from tabname where 1=1
order by CHARINDEX(RTRIM(CAST(列名 as NCHAR)),优先级1内容,优先级2内容,优先级3内容')
举例:
SELECT *FROM [Demo1].[dbo].[sortdemo] order by CHARINDEX(RTRIM(CAST( daima as NCHAR)), '11,22,33' )
执行结果
第一种方式:
select * from tabname where 1=1
order by CHARINDEX(RTRIM(CAST(列名 as NCHAR)),优先级1内容,优先级2内容,优先级3内容')
举例:
SELECT *FROM [Demo1].[dbo].[sortdemo] order by CHARINDEX(RTRIM(CAST( daima as NCHAR)), '11,22,33' )
执行结果