Oracle Enterprise Solutions & Architecture
Pages
Home
Oracle APEX Change Management System | Yasser Hassan Portfolio
Oracle Change Management System Demo
SQL Fundamentals
SQL Fundamentals II
PHP
SQL PLUS
PL/SQL
Forms and Reports
HTML5
JavaScript
Java
PL/SQL Collections and Records
PL/SQL Transactions
Ref Cursors
PL/SQL Analytic Functions
Problems and solves
Oracle Indexes
Work Samples
Record & Collection
Conditional statements
LOOP
Triggers
Object Oriented
NLS_LANG
Oracle Interview Question
About Me
Contact Me
Privacy Policy
Saturday, June 13, 2015
Oracle find 7th highest salary of an employee from a table
Here you can find 7th highest sal
SELECT *
FROM emp a
WHERE (7) = (
SELECT COUNT( DISTINCT ( E.Sal ) )
FROM emp E
WHERE e.Sal >= a.Sal
)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment