SELECT *
FROM (SELECT e.* ,ROW_NUMBER () OVER (ORDER BY salary DESC) rn
FROM employees e)
WHERE rn = 2;
Subscribe to:
Post Comments (Atom)
-
Search by keyword from Oracle Database Objects. select owner, type, name, line, text from dba_source where 1 = 1 and text like '%TEXT Y...
-
We Can Export Application Components individually from Oracle Apex. Application > Shared Components > Export Application Compo...
No comments:
Post a Comment