can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com

Answer Posted / mahesh

Select max(sal) from emp
where id='1233' and Sal< (select max(sal) from emp)

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain candidate key, alternate key, and composite key?

559


How to find the second highest salary of an employee?

561


What is mean by candidate key?

516


Is it ok to shrink transaction log?

490


Explain about Normalization?

542






What is log shipping? Can we do logshipping with SQL Server 7.0 ?

551


What is the difference between for xml raw and for xml auto?

543


What is difference between createstatement and preparedstatement?

515


How do you trace the traffic hitting a sql server?

593


What does null mean?

580


Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

475


Explain in brief about Microsoft SQL server?

519


What is the maximum row of a size?

546


What do you understand by physical_only option in dbcc checkdb?

558


What is database isolation in sql server? : sql server database administration

543