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)

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

0 Answers  

What is a transaction and why is it important?

0 Answers  

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

0 Answers  

What is transact-sql ddl trigger?

0 Answers  

Explain the collation?

0 Answers  

Explain various data region available in ssrs with their use?

0 Answers  

What is use of attributehierarchyenabled? : sql server analysis services, ssas

0 Answers  

What are the advantages of user defined function?

0 Answers  

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

0 Answers  

How to create stored procedures with parameters in ms sql server?

0 Answers  

What is a view? is View updatable?

17 Answers   IBM, L&T,

please can anyone answer this query Table 1 has 2 columns: EmployeeId,Age Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region who has the oldest person

10 Answers