select A.操作员,A.操作时间,A.内容 from a as A,(select 操作员 as X, max(操作时间) as Y from a group by 操作员)B where A.操作时间=B.y and A.操作员=B.操作员 group by A.操作员
select * from ( select t.* ,row_number() over (partition by 操作员 order by 操作时间 desc) seq from a) where seq = 1
1. select * from test_01 t where (t.code,t.des_date) in (select tt.code,max(tt.des_date) from test_01 tt group by tt.code) 2. select a.code,a.des_date,a.description from ( select t.code,t.des_date,t.description,rank() over(partition by t.code order by t.des_date desc) rank from test_01 t ) a where a.rank=13. select * from ( select t.code,t.des_date,t.description,row_number() over(partition by t.code order by t.des_date desc) rank from test_01 t ) a where a.rank=1
from a
group by 操作员
from a as A,(select 操作员 as X, max(操作时间) as Y
from a
group by 操作员)B
where A.操作时间=B.y
and A.操作员=B.操作员
group by A.操作员
select t.* ,row_number() over (partition by 操作员 order by 操作时间 desc) seq from a)
where seq = 1
1.
select * from test_01 t
where (t.code,t.des_date) in (select tt.code,max(tt.des_date) from test_01 tt group by tt.code) 2.
select a.code,a.des_date,a.description from
(
select t.code,t.des_date,t.description,rank() over(partition by t.code order by t.des_date desc) rank from test_01 t
) a
where a.rank=13.
select * from
(
select t.code,t.des_date,t.description,row_number() over(partition by t.code order by t.des_date desc) rank from test_01 t
) a
where a.rank=1