本文介绍了一种使用 SQL 的 identity 函数来生成自增 ID 的方法，并结合分组查询展示如何选取特定分组下的最小 ID 记录。
方法:
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 identity(int,1,1) as autoID, * into Tmp from aaselect min(autoID) as autoID into Tmp2 from Tmp group by bselect * from Tmp where autoID in(select autoID from tmp2) 
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
