Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 153798 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / shivaprasad
Hi Every one,this query will helps you to find 1st or 2nd or
3rd or and so on salary from the employee table.
change inside distinct top (3) for respective results
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 ? | 1 Yes | 0 No |
Answer / narendra
select max(company_id) from company where company_id <
(select max(company_id) from company where company_id <
(select max(company_id) from company))
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sabapathi
select sal from employee
where sal=(select min(sal) from employee
where sal>(select min(sal) from employee
where sal>(select min(sal) from employee)))
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / mohd. rashid
SELECT TOP 1 salary
FROM(
SELECT DISTINCT TOP 3 salary
FROM employee
ORDER BY salary DESC)
ORDER BY salary
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ravindra
select max(sal) from emp where sal < (select max(sal) from emp where sal < (select max(sal) from emp));
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / santhoshkumar
select name,salary from emp where salary=(select min(sal)
from (select distinct TOP 3(salary) from emp order by
salary desc;
| Is This Answer Correct ? | 5 Yes | 5 No |
Answer / ram pravesh
select max(sal) from emp where sal<(select max(sal)from emp
where sal<(select max(sal) from emp))
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / pardeep kumar
This is the Simplest One
Let i have a Column named EmpSal in Tbale Named tbEmp
Select Min(EmpSal) from tbEmp where EmpSal IN(Select
Distinct Top 3 EmpSal from tbEmp ORDER BY EmpSal DESC)
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / ashok naik
In Sql server:
Select top 1 ThirdHighest.salary from(
Select distinct top 3 salary from employee order by salary
desc) as ThirdHighest
--example for 4th highest salary in above query put 4
inplace of 3
--example for 5th highest salary in above query put 5
inplace of 3
--and so on for nth highest
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / harikrishna ravipati
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 |
Explain view?
what is unique key?
14 Answers Amazon, Cap Gemini, Infosys, Wipro,
State and explain about oracle instance?
What do you know about normalization? Explain in detail?
How to connect to a remote server?
How to Select second Maximum salary in a Table ?
11. Display the client number and name and the client number and name of the person who referred that client.
What is not equal to in oracle?
If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X
What is a package ? What are the advantages of package ?
Define Normalization with example?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
Oracle General 
