Find out the 3rd highest salary?
Answers were Sorted based on User's Feedback
Answer / ritesh sabanis
select max(sal) from employeedata where sal <
(select max(sal) from employeedata where sal not in(select
max(sal)from employeedata)) ;
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / divya c
Select max(sal) from emp
where sal<(select max(sal) from emp where sal<(select max
(sal) from emp));
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / lalit dwivedi
select a.salary
from emp a
where 3=(select count(distinct(b.salary))
from emp b
where a.salary<=b.salary)
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / dharmendra yadav
select min(salary) from (select name , salary , rownum from
Emp order by salary desc) where rownum <= 3 ;
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / jeevitha
select distinct a.salfrom emp a where &n= (select count
(distinct(b.sal)from emp b where a.sal<= b.sal)
-----
enter the highest sal of n:2,3.....n
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / suba
(Instead of 3 we can find N highest value)
select min(sal) from emp e where 3>(select count(sal) from
emp where sal>e.sal);
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / kumar
select*from(select rownum rn,sal from(select*from emp order by sal desc))where rn=3
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / aarti verma
get the 3rd highest salary:
SELECT DISTINCT salary from employee e ORDER BY salary DESC
LIMIT 2,1;
get the records of employees having 3rd highest salary:
SELECT * FROM employees WHERE salary = (SELECT DISTINCT
salary from employee e ORDER BY salary DESC LIMIT 2,1);
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / himanshu
SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP 3 salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary
Is This Answer Correct ? | 0 Yes | 0 No |
SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP 3 salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary
Is This Answer Correct ? | 0 Yes | 0 No |
what will be the output: select 1 from emp union all select 2 from emp;
How do you modify a trigger?
What is difference between sql and excel?
explain the difference between myisam static and myisam dynamic. : Sql dba
What is the difference between delete, truncate and drop command?
Does view contain data?
What is the criteria while applying index to any column on any table.
How can triggers be used for the table auditing?
What if we write return in procedure?
how to delete duplicate rows from a specified table(only single table) how do you know which join is need to be used
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
Maximum how many triggers can we use in trigger and How to find out how many records it fetched.