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 do you understand by pl/sql packages?
What is oracle sql developer?
what is a relationship and what are they? : Sql dba
How do I start sql from command line?
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
What is a database trigger ? Name some usages of database trigger ?
What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry.
What kind of join is join?
Does access use sql?
how many values can the set function of mysql take? : Sql dba
What are the set operators in sql?
I have 2 Databases. How can create a table in particular database? How can i know the list of tables presented each database?( in oracle 10g)