取Group by 的第几个分组的方法

最新推荐文章于 2022-08-18 18:03:13 发布

daviszr_1979

最新推荐文章于 2022-08-18 18:03:13 发布

阅读量385

点赞数

分类专栏： sql Server 文章标签： table insert

本文链接：https://blog.youkuaiyun.com/daviszr_1979/article/details/4321764

版权

sql Server 专栏收录该内容

24 篇文章

订阅专栏

Create Table #temp1
(
syopid nvarchar(16),
maname nvarchar(20),
systemtime datetime
)

insert into #temp1(syopid,maname,systemtime)
Select 'zr1','ma001','2009-07-01 00:00:00' Union all
Select 'zr1','ma002','2009-07-02 00:00:00' Union all
Select 'zr1','ma003','2009-07-03 00:00:00' Union all

Select 'lidong1','ma001','2009-07-01 00:00:00' Union all
Select 'lidong1','ma002','2009-07-02 00:00:00' Union all
Select 'lidong1','ma003','2009-07-03 00:00:00' Union all

Select 'wangchubo1','ma001','2009-07-01 00:00:00' Union all
Select 'wangchubo1','ma002','2009-07-02 00:00:00' Union all
Select 'wangchubo1','ma003','2009-07-03 00:00:00'

Select syopid,maname,systemtime From #temp1 Where systemtime in
(
Select systemtime from
(select row_number() Over(order by systemtime) as id,systemtime From #temp1 Group by systemtime) A
Where A.id=1
)
drop table #temp1