Find out the 3rd highest salary?
Answers were Sorted based on User's Feedback
Answer / durgashivashankar
select min(sal) from (Select rownum,sal FROM emp> Order
by sal desc)
where rownum<=3
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nikhilesh roy
WITH
CTE as
(select emp_id,salary,rn=row_number() over (order by salary desc) from emp_table )
select * from CTE where rn=3;
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / virendra
select ename, salary from emp where salary=(select top 1
salary from (select distinct top 3 salary from emp order
by salary desc) a order by salary)
Is This Answer Correct ? | 7 Yes | 8 No |
Answer / ajay kumar
SELECT DISTINCT SAL FROM EMP WHERE SAL = (SELECT DISTINCT
SAL FROM EMP X WHERE &N= (SELECT COUNT(DISTINCT SAL) FROM
EMP Y WHERE Y.SAL>X.SAL))
/
AFTER RUNNING THE QUERY PUT THE VALUE OF N
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / sachin saini
select min(salary) from table_name where salary in(select
top 3 salary from table_name order by salary desc )
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / abhijt shinde
select MIN(salary) from Employees
where salary IN
(Select Top 3 salary from Employees order by salary desc)
Select Top 1 salary from Employees where salary
Not IN(select Top 1 salary from Employees order by salary Desc)
order by salary Desc
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / arindam
select min(sal) from
(
select sal from
(
select distinct sal from emp order by sal desc
)
where rownum<=3
)
where rownum <4
Is This Answer Correct ? | 5 Yes | 7 No |
Answer / srikanth
select * from (select e.*,rank() over(order by salary desc
nulls last) sal_rnk from employee e)where sal_rnk=3;
Is This Answer Correct ? | 3 Yes | 5 No |
Answer / vishal beri
Select ename from emp e where 2=(select count(distinct(Sal))
from emp where sal>e.sal)
Is This Answer Correct ? | 3 Yes | 5 No |
Answer / suneel
select level,max(sal)from af where level=3 connect by prior
sal>sal group by level;
Is This Answer Correct ? | 8 Yes | 11 No |
difference between table level constraint and column level and advantages of table level constraint
Is json a nosql?
How to pipe multiline string to isql?
find the third highest salary?
Why is stored procedure faster than query?
What is function and procedure in pl sql?
what is meant by tuning and tk proof?
How do you update sql?
What are tables in sql?
How do I start sql profiler?
What is an intersect?
How to run sql commands in sql*plus?