WITH A AS (SELECT 1 M,'開1' N FROM DUAL
UNION
SELECT 101 M,'開2' N FROM DUAL
UNION
SELECT 10101 M,'開3' N FROM DUAL
)
SELECT A.M,
A.N,
ROW_NUMBER () OVER(PARTITION BY 1 ORDER BY A.M) AS SEQ
FROM A請問哈各位大俠,這里的PARTITION BY 1是什么意思啊?
郁悶中.............
UNION
SELECT 101 M,'開2' N FROM DUAL
UNION
SELECT 10101 M,'開3' N FROM DUAL
)
SELECT A.M,
A.N,
ROW_NUMBER () OVER(PARTITION BY 1 ORDER BY A.M) AS SEQ
FROM A請問哈各位大俠,這里的PARTITION BY 1是什么意思啊?
郁悶中.............
解决方案 »
- 救命:select报ORA-01036: illegal variable name/number
- ORACLE监听器不支持服务问题,急问,谢谢!
- 10g(10.2)无法访问企业管理器
- oracle 多表更新问题
- 有谁能告诉我“ORA-03113:通信通道的文件结束”是什么问题。
- oracle8i或9i哪有下载的?
- 怎样让游标遍历定制的数据集合???用数组?集合?我不会写,请赐教
- Oracle 急啊~~~~
- 通过 BDE 操作 ORACLE8I 数据库中表文件的问题
- 关于触发器
- plsql里怎么取得byte数?
- trailing null missing from STR bind value
1 A
2 A
3 A
1 B
2 B如果没有 partition by,则整表一起排序