find out the third highest salary?
Answers were Sorted based on User's Feedback
Answer / divya
select min(sal) from salarytbl where sal in(select distinct
top 3 sal from salarytbl order by sal desc)
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / shivaprasad
select distinct top 1 Salary from(select distinct top 3
Salary from Employee order by Salary DESC)temp order by
Salary;
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / paridhi
select top 1 salary from
(select top 1 salary from employee order by
salary desc) a
order by salary
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / santanu
3rd highest salary:
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 / shashi kumar
Select * from emptable e1 where(N=(select
count(DISTINCT(e2.empsal))from emptable e2 where
e2.empsal>=e1.empsal))
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nitin berwal
select top 1 salary from(select top 3 salary from emp order
by desc) a
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / deepal saini
this is the best way to find out thethird highest salary from emp table
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 / gaurav
try this
select max(salary)
from employees
where salary < (select max(salary)
from employees
where salary < (select max(salary)
from employees));
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / prithvi
select Max(sal) from emp
This will give us 1highest sal
Select Max (sal) from where sal <(select Max(sal) from emp)
Select Max (sal) from where sal <(Select Max (sal) from
where sal <(select Max(sal) from emp))
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / siddharth mitra
select *
from (select row_number() over (order by salary asc) as
"ROW_NUM" from emp)
where ROW_NUM = 3;
This only works with oracle 8i and 9i,i.e., row_number is an
analytic function.
Is This Answer Correct ? | 0 Yes | 0 No |
What does COMMIT do ?
why pl sql doesn't support retrieving multiple records
Where are the settings stored for each instance in oracle?
What is a public synonym?
how to retrive xml data for using sql query?
What is the Difference between 1) ER MODEL and Relational Model 2) Dense Index and Sparse Index
How to change program global area (pga) in oracle?
What is the relation of a user account and a schema?
when i run my query on yesterday it is fast but today it is slow why?
how to insert the image in table
what are archived logs?
How many data types are supported?