方法:
select
identity
(
int
,
1
,
1
)
as
autoID,
*
into
Tmp
from
aa
select min (autoID) as autoID into Tmp2 from Tmp group by b
select * from Tmp where autoID in ( select autoID from tmp2)
select min (autoID) as autoID into Tmp2 from Tmp group by b
select * from Tmp where autoID in ( select autoID from tmp2)