Answer / dileep.t

If you need the second highest salary only
then following will also work,

select Max(Salary) from TableName
where Salary not in(
Select Max(Salary) from TableName)

Answer / preeti chauhan

CREATE TABLE T1(SALARY int, [NAME] varchar(50))
SELECT TOP 1 SALARY FROM (SELECT TOP 2 SALARY FROM T1 ORDER
BY SALARY DESC)T1 ORDER BY SALARY

Answer / kumar_kisna

select max(salary) from table where salary<(select max
(salary) from table)

Answer / divya

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

Answer / arun kumar ks

In the case more than one highest SALARY, only the Dilip’s
answer is correct.

Answer / sabin v jacob

SELECT Min(Sal) FROM (SELECT TOP 2 Sal FROM emp ORDER BY
Sal desc) as Temp

or

SELECT Min(Sal) FROM emp WHERE Sal IN(SELECT TOP 2 Sal FROM
emp ORDER BY Sal DESC)

Answer / rajendra

Select Top 1 * From Tablename where salary in
(select top 2 salary from tablename order by salary desc)
order by salary asc

Answer / neeru

I think Daleep answer is not so precise, if you want 3rd or
ny specified answer, this only can only be seems right for
2nd highest salary, else, its not optimise query.I found
Preeti's query more optimistic and accurate.

Answer / selvaraj.v

In SQL Server 2000 Query:
-------------------------

select max(salary) from Employee where salary not in(select
max(salary) from employee)

This Query only selects the 2'nd Higehest Salary in that
table. So, you will try...

Answer / harikumar

select max(salary) as secondMax from employee where id <>
(select max(salary) from employee)

What are types of subqueries?

0 Answers  

If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?

3 Answers  

could u plz explain about joins and views?

2 Answers  

Can you please differentiate between a primary key and a unique key?

0 Answers  

What are the types of backup and tell me the difference between full and differential backup?

4 Answers   CTS, TCS,

What is the difference between Clustered and Non-Clustered Index?

0 Answers  

How you can get the list of largest tables in a database?

0 Answers  

we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age.How? Any Body Plz

6 Answers  

How many types of triggers are there?

0 Answers  

Delete duplicate rows without using rowid.

0 Answers   Nagarro,

Can you explain the disadvantages/limitation of the cursor?

0 Answers  

What is policy based management (pbm)? : sql server database administration

0 Answers