how to find the employee who get seventh largest salary in the company?

Code
 
SELECT salary FROM 
(SELECT salary, dense_rank() over (ORDER BY salary) 
FROM emp) 
WHERE dense_rank = 7; 
 

select salary data only

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.