22,207
社区成员
发帖
与我相关
我的任务
分享
Select Name
From (
Select *
From tb1 a
Where sn=(select min(sn) From tb1 b Where a.name=b.name)
)
Order By sn
--测试数据
if not object_id(N'Tempdb..#T') is null
drop table #T
Go
Create table #T([sn] int,[name] nvarchar(22))
Insert #T
select 1,N'张1' union all
select 2,N'张1' union all
select 3,N'李2' union all
select 4,N'李3'
Go
--测试数据结束
SELECT name
FROM ( SELECT name ,
MIN(sn) AS sn
FROM #T
GROUP BY name
) t
ORDER BY sn