id name date 编号
1 你 2004-1-1 1
1 你 2004-1-2 2
1 你 2004-1-8 3
2 你 2004-8-8 1
2 我 2004-5-1 1
2 我 2004-5-2 2--你用数据来试一下就知道了。
1 你 2004-1-1 1
1 你 2004-1-2 2
1 你 2004-1-8 3
2 你 2004-8-8 1
2 我 2004-5-1 1
2 我 2004-5-2 2--你用数据来试一下就知道了。
解决方案 »
- Oracle行级触发器可以知道是那条数据触发的嘛?
- oracle 10g改过sga参数后启动数据库失败
- 谁知道Oracle PL/SQL的好书 推荐一下
- Oracle数据库安装的时候需要注意什么.?
- oci里面能不能调用pl\sql啊? 能的话 给个例子吧
- 很简单的问题
- 一个关于统计的问题,急,谢谢
- 讨论,利用vb作oracle的数据库开发,连接方式ado,似乎很方能能存取各种类型的数值,但是存放clob类型的字段,字段值超过一定长度就会死机
- can i update two columns at one time?
- 如何在一个数据库的过程中连结另一个数据库!!!
- 急:.net连接oracle9的问题
- 我遇到了toad的启动问题,toad一闪就没了
ROW_NUMBER
Syntax
row_number::=
Text description of row_number
See Also:
"Analytic Functions" for information on syntax, semantics, and restrictions
Purpose
ROW_NUMBER is an analytic function. It assigns a unique number to each row to which it is applied (either each row in the partition or each row returned by the query), in the ordered sequence of rows specified in the order_by_clause, beginning with 1.You cannot use ROW_NUMBER or any other analytic function for expr. That is, you can use other built-in function expressions for expr, but you cannot nest analytic functions.See Also:
"About SQL Expressions" for information on valid forms of expr
Examples
For each department in the sample table oe.employees, the following example assigns numbers to each row in order of employee's hire date:SELECT department_id, last_name, employee_id, ROW_NUMBER()
OVER (PARTITION BY department_id ORDER BY employee_id) AS emp_id
FROM employees;DEPARTMENT_ID LAST_NAME EMPLOYEE_ID EMP_ID
------------- ------------------------- ----------- ----------
10 Whalen 200 1
20 Hartstein 201 1
20 Fay 202 2
30 Raphaely 114 1
30 Khoo 115 2
30 Baida 116 3
30 Tobias 117 4
30 Himuro 118 5
30 Colmenares 119 6
40 Mavris 203 1
.
.
.
100 Popp 113 6
110 Higgins 205 1
110 Gietz 206 2
ROW_NUMBER is a nondeterministic function. However, employee_id is a unique key, so the results of this application of the function are deterministic.