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.

difference between truncate, delete aur drop?

2 Answers  

What is a data source file?

1 Answers  

List the ways in which dynamic sql can be executed?

0 Answers  

what is index seek and index scan?

2 Answers  

What are the advantages of user-defined functions over stored procedures in sql server?

1 Answers  

What is hot add cpu in sql server 2008?

1 Answers  

What is a database table?

1 Answers  

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers   RND Soft, Wipro,

What gets stored inside msdb database?

1 Answers   Abacus,

Why truncate is ddl command?

1 Answers  

what purpose does OPENXML clause have in sql server stored procedure?

1 Answers  

How to delete duplicate rows?

1 Answers