Bala

• Aug 25th, 2012

 

Code
 


SELECT salary FROM 


(SELECT salary, dense_rank() over (ORDER BY salary) 


FROM emp) 


WHERE dense_rank = 7; 


 

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
 SQL>SELECT DISTINCT SAL FROM EMP E WHERE 7>=(SELECT COUNT (DISTINCT SAL) FROM EMP A WHERE A.SAL>=E.SAL) ORDER BY SAL DESC

jamakucky

• Jan 5th, 2015

 

Code
SELECT emp_name,salary


FROM employee


WHERE salary = (


SELECT DISTINCT salary


FROM employee


ORDER BY salary DESC


OFFSET 6 ROWS FETCH NEXT 1 ROWS ONLY)

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;