Answer / arun ashok

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

Answer / sandeep rana

Select top 1 salary from table where salary in(select top 2
salary from table order by salary desc)order by salary

Answer / pravin

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

Answer / prasad237

with x as(select row_number over(order by sal desc) as rid,* from emp)
select * from x where rid=n
we can retrieve nth max sal

Answer / syaam

select a.sal from emp a
where 2=(select count(distinct b.sal) from emp b
where a.sal<= b.sal)


for getting nth max sal ..replace 2 by n


all the best

Answer / swapnl

select max(sal) from emp_det where sal not in (
select max(sal) from emp_det);

Answer / raj

Sabin's answer is perfect and simple

Answer / kumar

1 My Second Answer.

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

Explain few of the new features of sql server 2008 management studio

0 Answers  

List some of the rules that apply to creating and using a ‘view’

0 Answers  

write the query for taking database backup in sql

10 Answers   ABC, IBM, Logica CMG, MA,

Can sql server be linked with other servers like oracle?

0 Answers  

What is a join and their types?

2 Answers   Challenger Financial,

What is default port number for sql server 2000?

0 Answers  

What is the sql case statement used for? Explain with an example?

0 Answers  

What is the native system stored procedure to execute a command against all databases?

0 Answers  

How many triggers you can have on a table?

0 Answers  

What is Schema in Database?

1 Answers   Cap Gemini,

Tell me about the approaches which you used to counter the DI problems.

0 Answers   EXL,

What do you mean by a Composite primary key?

0 Answers   Genpact,