row_number() over(PARTITION BY
来源:互联网 发布:汇丰软件开发有限公司 编辑:程序博客网 时间:2024/05/16 09:58
1.create table lcy_p(id number,name varchar2(30));
2.insert into lcy_p values(1,'li1');
insert into lcy_p values(1,'li2');
insert into lcy_p values(2,'wang1');
insert into lcy_p values(2,'wang2');
insert into lcy_p values(3,'hu1');
insert into lcy_p values(3,'hu2');
insert into lcy_p values(4,'gan');
insert into lcy_p values(5,'xin');
insert into lcy_p values(6,'kai');
insert into lcy_p values(7,'nan');
3.select * from (select row_number() over(PARTITION BY ID ORDER BY NAME) AS ROW_NO,
p.*
from lcy_p p )X
WHERE ROW_NO =1;
result:
ROW_NO ID NAME
1 1 li1
1 2 wang1
1 3 hu1
1 4 gan
1 5 xin
1 6 kai
1 7 nan
- row_number() over(PARTITION BY
- row_number() over(partition by ... )
- row_number() over(partition by
- row_number() over (partition by) 使用
- ROW_NUMBER() OVER (PARTITION BY ... ORDER BY ...)
- row_number() over (partition by....order by...)用法
- row_number() over (partition by....order by...)用法
- row_number() over (partition by....order by...)用法
- Oracle 分析函数 ---OVER(),row_number(),partition by
- row_number() OVER(PARTITION BY)函数介绍
- row_number() over 与partition by 用法
- row_number() OVER(PARTITION BY)函数介绍
- row_number() OVER(PARTITION BY)函数介绍
- row_number() OVER(PARTITION BY)函数介绍
- t-sql row_number()over(partition by 使用说明
- row_number() OVER(PARTITION BY)函数介绍
- row_number() OVER(PARTITION BY)函数介绍
- row_number() OVER(PARTITION BY)函数介绍
- Puppet 使用方法总结
- PKU 1651 Multiplication Puzzle
- javascript 基础
- 记录我的Linux学习之路1
- 八款JS框架介绍及比较
- row_number() over(PARTITION BY
- 我们要完成哪些“软件”的更新——仅有高学历,无法拯救未来
- ExtJS,JQuery,Dojo的小比较
- 几款JS框架的比较
- 文曲星猜数游戏
- 240多个jQuey插件
- Lnux2.6内核udev机制(基于2.6.26
- Java中对文件的操作
- win8 第一个 应用