can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
Answer Posted / rajendra
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 ? | 2 Yes | 0 No |
Post New Answer View All Answers
Is it possible for a stored procedure to call itself or recursive stored procedure?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
What is sql server profiler trace data file?
What are the advantages of mirroring?
what changed between the previous version of sql server and the current version? : Sql server database administration
How to create a new login name in ms sql server?
What is the sql profiler?
What are the lambda triggers?
What are the differences between clustered and non-clustered index?
Which joins are sql server default?
Tell me what is difference between view and materialized view?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
Write a SQL command to insert and update only a particular field?
What is data modification?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?