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
Explain candidate key, alternate key, and composite key?
How to find the second highest salary of an employee?
What is mean by candidate key?
Is it ok to shrink transaction log?
Explain about Normalization?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
What is the difference between for xml raw and for xml auto?
What is difference between createstatement and preparedstatement?
How do you trace the traffic hitting a sql server?
What does null mean?
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
Explain in brief about Microsoft SQL server?
What is the maximum row of a size?
What do you understand by physical_only option in dbcc checkdb?
What is database isolation in sql server? : sql server database administration