Oracle Apps Fusion Blog(Forms, Reports, Oracle Application Technical, SQL, PL/SQL, OAF)
(Move to ...)
Home
▼
Monday, October 23, 2017
Finding nth row of a table
SELECT * FROM scott.EMP A WHERE &n = (SELECT COUNT(*) + 1 FROM scott.EMP B WHERE A.ROWID > B.ROWID)
No comments:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment