排列顺序

最新推荐文章于 2021-07-27 17:35:48 发布

xue5ya

最新推荐文章于 2021-07-27 17:35:48 发布

阅读量348

点赞数

分类专栏： SQL 文章标签： insert table

本文链接：https://blog.csdn.net/xue5ya/article/details/3227817

版权

SQL 专栏收录该内容

0 篇文章 0 订阅

订阅专栏

declare @t1 table (id int,field nvarchar(5))
insert into @t1 select 3,N'记录1'
     union all select 2,N'记录2'
     union all select 1,N'记录2'
     union all select 2,N'记录1'
    union all select 3,N'记录2'
     union all select 1,N'记录1'
select *
from @t1
where id in (1,2)
order by
    case id
         when 1 then 1
         when 2 then 2
    end

declare @t1 table (id varchar(5),field nvarchar(5))
insert into @t1 select 3,N'记录1'
     union all select 2,N'记录2'
     union all select 1,N'记录2'
     union all select 2,N'记录1'
    union all select 3,N'记录2'
     union all select 1,N'记录1'
select *
from @t1
where id in (1,2)
order by charindex (','+id+',',',1,2,')