select deptno,EMPNO,ENAME ,sal,
rank() over(partition by deptno order by empno) seq
from emp;
DEPTNO EMPNO ENAME SAL SEQ
---------- ---------- ---------- ---------- ----------
10 1000 JJ 3000 1
10 1000 xx 1
10 7781 3
10 7781 3
10 7781 CLARK 2572.5 3
10 7782 CLARK 2450 6
10 7839 KING 5000 7
10 7934 MILLER 1300 8
20 7566 JONES 2975 1
20 7788 SCOTT 3000 2
20 7876 ADAMS 1100 3DENSE_RANK
select deptno,EMPNO,ENAME ,sal,
dense_rank() over(partition by deptno order by empno) seq
from emp;
DEPTNO EMPNO ENAME SAL SEQ
---------- ---------- ---------- ---------- ----------
10 1000 JJ 3000 1
10 1000 xx 1
10 7781 2
10 7781 2
10 7781 CLARK 2572.5 2
10 7782 CLARK 2450 3
10 7839 KING 5000 4
10 7934 MILLER 1300 5
20 7566 JONES 2975 1
20 7788 SCOTT 3000 2
20 7876 ADAMS 1100 3来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10314474/viewspace-660370/ ，如需转载，请注明出处，否则将追究法律责任。
最新文章
- C#之Equals与==
- Spring ： @SessionAttributes注解
- Spring: @ModelAttribute注解用法
- No qualifying bean of type 'javax.sql.DataSource' available: expected at least 1
- Spring Boot创建DataSource时遇到的错误：No supported DataSource type found
- Spring Boot无法对Service进行注入
- Spring Boot配置错误：Failed to determine a suitable driver class
- Spring Boot配置是遇到错误：jdbcUrl is required with driverClassName
- Eclipse中使用Mybatis Generator遇到的错误
- Spring Boot + Mybatis + Spring MVC环境配置（五）：templates模板使用
