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)

How to know whether our backup is succesfully taken?

1 Answers  

What is normalization? Explain different forms of normalization?

0 Answers  

What is difference between table aliases and column aliases? Do they affect performance?

0 Answers  

1. What are the grouping function in SQL ? 2. If base table of a view deleted means, what will happen while we querying on view ? will give any error ? 3. Difference between DROP, DELETE, TRUNCATE table ? 4. What is constraints and types ? 5. What is max size of nchar & nvarchar ? 6. Define ROLLBACK, COMMIT, SAVE POINT 7. How non-clustered better ? or rank the Clustered, Non-Clustered and Table scan in performance wise 8. Select 10 rows from a table ? 9. Define DML, DDL, DCL, DTL commands ? 10. What is mean by NULL value ? NULL means "" or 0 or undefined ? 11. Default constraints ? 12. Can we have more then primary Key in table ? 13. Type of integrity ? Entity, Referential, Domain ?

10 Answers   Perot Systems,

Give main differences between "Truncate" and "Delete".

0 Answers   HCL,

How does normalization work?

0 Answers  

Explain go command in sql server?

0 Answers  

What is Cross Join

3 Answers  

How to delete exactly duplicate records from a table?

0 Answers  

What is delete query?

0 Answers  

What are the steps to follow to configure SQL*Net?

0 Answers   Tech Mahindra,

What stored by the master?

0 Answers