oracle 自增序列及分组查询取某一条（row_number()函数）

最新推荐文章于 2022-03-22 17:21:44 发布

chaoyuyuchaoi

最新推荐文章于 2022-03-22 17:21:44 发布

阅读量536

点赞数

分类专栏：数据库文章标签：数据库

本文链接：https://blog.csdn.net/chaoyuyuchaoi/article/details/84238616

版权

数据库专栏收录该内容

4 篇文章 0 订阅

订阅专栏

-- Create sequence 
create sequence SEQ_C_PICRECORD
minvalue 1
maxvalue 9999999999
start with 21
increment by 1
cache 20;

--Create trigger
create or replace trigger tri_c_picrecord
before insert on c_picrecord for each row
begin
  select seq_c_picrecord.nextval into:new.id from dual;
end;

select *
  from (select t.*,
               row_number() over(partition by car_num, car_numcolor order by cap_date) as rn from
  c_picrecord t) a
 where a.rn = 3