Oracle笔记--row_number rank dense_rank
来源:互联网 发布:wifi连不上网络 有信号 编辑:程序博客网 时间:2024/06/09 14:58
create table TEST001
(
EMPNO NUMBER(4),
ENAME VARCHAR2(50),
SAL NUMBER(8,4)
)
INSERT INTO TEST001 values(1,'James',1000);
INSERT INTO TEST001 values(1,'Allen',800);
INSERT INTO TEST001 values(2,'Ak',600);
INSERT INTO TEST001 values(1,'UC',800);
INSERT INTO TEST001 values(2,'Blake',600);
INSERT INTO TEST001 values(2,'Ward',300);
INSERT INTO TEST001 values(3,'Turner',1200);
测试
1.全局
select t.*,
row_number()over(order by sal) row_number,rank()over(order by sal) rank,
dense_rank()over(order by sal) dense_rank
from test001 t order by 3
row_number:按sal依次排序
rank :相同的值排名相同,然后跳跃增加
dense_rank:相同的值排名相同,然后递增
2.区内排序
select t.*,
row_number()over(partition by empno order by sal) row_number,
rank()over(partition by empno order by sal) rank,
dense_rank()over(partition by empno order by sal) dense_rank
from test001 t order by 1,3
- Oracle笔记--row_number rank dense_rank
- ORACLE Rank, Dense_rank, row_number
- Oracle:Rank,Dense_Rank,Row_Number比较
- oracle笔记(5)----排序函数row_number、rank、dense_rank
- Oracle:分析函数2(Rank, Dense_rank, row_number)
- oracle分析函数(rank(),dense_rank(),row_number())
- oracle分析函数Rank, Dense_rank, row_number
- oracle 分析函数Rank, Dense_rank, row_number
- oracle分析函数Rank, Dense_rank, row_number
- oracle分析函数Rank, Dense_rank, row_number
- oracle分析函数Rank, Dense_rank, row_number
- ORACLE分析函数(3)---rank,dense_rank,row_number
- oracle 分析函数 RANK、DENSE_RANK、ROW_NUMBER
- oracle分析函数Rank, Dense_rank, row_number
- oracle分析函数Rank, Dense_rank, row_number
- oracle分析函数Rank, Dense_rank, row_number
- oracle分析函数Rank, Dense_rank, row_number
- oracle 分组函数rank() over(),dense_rank(),row_number()
- html下拉菜单
- java 读取 dbf数据库的dbf文件代码
- Linked list cycle [leetcode]
- 字符串统计
- Vuex 模块化实现待办事项的状态管理
- Oracle笔记--row_number rank dense_rank
- 腾讯云服务器搭建SVN
- 《图解HTTP[上野宣]》读书笔记一
- HDU 1847 Good Luck in CET-4 Everybody! (SG函数)
- 优化查询sql
- 利用PL/SQL创建Oracl外部表
- 关于EXCEL操作
- JavaScript 实现倒计时代码
- python网络爬虫入门(二)——百度贴吧