11,849
社区成员
发帖
与我相关
我的任务
分享
create table Table_1
(
id int,
v varchar(128),
n int
)
insert into Table_1
select 10561,'1111',0 union all
select 10565,'2222',0 union all
select 10572,'3333',0
go
;with cte as
(
select
* ,
row_number() over(order by n) as num
from Table_1
)
select id,v,n from cte where num=1