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 |
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
How to define an anonymous block?
What is the relation of a user account and a schema?
what is RAID technology?which is better RAID 0+1 OR RAID 5?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
How to define an anonymous procedure without variables?
8. Display the client name and order date for all orders using the natural join keywords.
What is oracle and what are its different editions?
What is a table in oracle?
what are corelated subqueries
which language is used to develop the oracle........?
How to create a new view in oracle?