can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
Answer Posted / 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.
Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
How to achieve Paging of records in SQL SERVER?
Explain isolation levels that sql server supports?
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
What are the indexes in sql server?
Where sql server usernames and passwords are stored in a sql server?
What is attribute hierarchy? : sql server analysis services, ssas
What is the use of for clause?
What is the default schema of your login session in ms sql server?
Explain about sql server login?
What is collation?
Why and when do stored procedure recompile?
What is @@rowcount in sql?
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
What is the recursive stored procedure in sql server?
What is tablesample?