Bala

• Aug 25th, 2012

 

Code
 

gowtham

• Oct 1st, 2012

 

select salary data only

Amninder

• Apr 15th, 2013

 

Select emp_id,emp_name,salary from employee a,
(Select salary,dense_Rank() over (order by salary DESC) rank_sal from employee)b
where a.salary=b.salary
and rank_sal=7;
The Inline Query will order salary by descending order and will correspondingly rank them, and by joining the salary present at 7th number with the main table, we can find the required data.

dinesh

• Jul 23rd, 2013

 

Code
 

jamakucky

• Jan 5th, 2015

 

Code
 

obaid

• Jan 7th, 2015

 

Select top(7) salary from employee where order by salary desc

Nikita Patil

• Jan 11th, 2015

 

SELECT ENAME FROM (SELECT * FROM EMP ORDER BY SAL DESC )
WHERE ROWNUM<=7
MINUS
SELECT ENAME FROM (SELECT * FROM EMP ORDER BY SAL DESC )
WHERE ROWNUM<=6;

Binod

• May 26th, 2015

 

SELECT MIN(SALARY) FROM
(SELECT DISTINCT SALARY FROM EMPLOYEE
ORDER BY SALARY DESC)
WHERE ROWNUM<=7;