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;

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))

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)))

Answer / mohd. rashid

SELECT TOP 1 salary
FROM(
SELECT DISTINCT TOP 3 salary
FROM employee
ORDER BY salary DESC)
ORDER BY salary

Answer / ravindra

select max(sal) from emp where sal < (select max(sal) from emp where sal < (select max(sal) from emp));

Answer / santhoshkumar

select name,salary from emp where salary=(select min(sal)
from (select distinct TOP 3(salary) from emp order by
salary desc;

Answer / ram pravesh

select max(sal) from emp where sal<(select max(sal)from emp
where sal<(select max(sal) from emp))

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)

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

Answer / harikrishna ravipati

select max(sal) from emp where sal <
(select max(sal) from emp where sal <
(select max(sal) from emp))

Explain can a view based on another view?

1 Answers  

How to rename an index?

0 Answers  

How will you write a query to get a 5th rank student from a table student_report?

0 Answers  

What are the trigger associated with image items ?

1 Answers   Oracle,

List the types of joins used in writing subqueries?

0 Answers  

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

0 Answers  

what is the scripts in data base?

0 Answers  

how to retrieve daily sal from emp table in oracle 10g

2 Answers   Infosys,

Maximum how many triggers can be updated in table ?

5 Answers   Accenture, Cap Gemini,

What is the quickest way to export a table to a flat file?

0 Answers  

Which is better Oracle or MS SQL? Why?

2 Answers   Bally Technologies,

how to use sequence and what use of sequence cache

1 Answers