can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
Answer Posted / darshan shah
select top 1 * from (select top 2 * from emp order by sal
desc ) a order by sal asc
Plz try this.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are sql server functions?
How do you identify a foreign key?
What are the types of stored procedures in an sql server?
What types of replication are supported in sql server?
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
What are different types of statements that are supported by sql?
Difference between report and query parameter. Why do we need different type of parameter?
How to find the service pack installed? : sql server database administration
What is mapping schema?
Is it true, that there is no difference between a rule and a check constraint?
What are the two authentication modes in sql server?
what are the different types of replication you can set up in sql server? : Sql server database administration
How to apply cascading referential integrity in place of triggers?
What is the federation in sql azure?
Define Unique Key?