34,837
社区成员




Use tempdb
GO
Create table dbo.wzbm
(w_name varchar(10),bm int,dw int )
Go
Insert Into dbo.wzbm values('a',1,2),('a',2,3),('b',2,3)
Go
with tb as
(
Select *,ROW_NUMBER() Over (Order by w_name) as rn
From dbo.wzbm
)
Select t1.w_name,t1.bm,t1.dw
From tb as t1
Where not exists
(Select *
From tb as t2
where t2.rn > t1.rn And t1.w_name = t2.w_name
)
你看这样行不,通过给表添加行号。
select *
from wzbm t
where not exists (select 1 from wzbm where w_name = t.w_name and bm > t.bm)