oracle 根据根据单列去重
DELETE FROM emp_test WHERE ROWID NOT IN(
SELECT MAX(ROWID) FROM emp_test GROUP BY job)
oracle 分页查询
SELECT * FROM (
SELECT e.*, ROWNUM rn FROM emp e WHERE ROWNUM<=10
) WHERE rn >=6
Sql
oracle 根据根据单列去重
DELETE FROM emp_test WHERE ROWID NOT IN(
SELECT MAX(ROWID) FROM emp_test GROUP BY job)
oracle 分页查询
SELECT * FROM (
SELECT e.*, ROWNUM rn FROM emp e WHERE ROWNUM<=10
) WHERE rn >=6
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
扫一扫
