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 |
define different types of trigger. : Sql dba
What is meant by cursor in sql?
what is meant by databases
Is inner join faster than left join?
Explain some predefined exceptions.
Is record in oracle pl sql?
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
What is faster join or subquery?
What are the advantages of sql?
how will you find out the last three records in a table with n no of records and delete them
what is the cursor and use of cursor in pl/sql ?
what is a stored procedure? : Sql dba