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 happens to the data files if a tablespace is dropped?
What is a cursor in oracle?
What do you mean by merge in oracle and how can we merge two tables?
What is the data pump import utility?
How to insert a record into a table?
What are group functions in oracle?
Explain a data segment?
What happens to the current transaction if a ddl statement is executed?
how to do daily transactions with out sql* loader control file regesterd in apps?
Describe the different type of Integrity Constraints supported by ORACLE ?
Explain can a view based on another view?
Define 'view' advantage ?