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
Can we use where clause with group by?
How many columns can exist together per table?
What gets stored inside msdb database?
What is the difference between ‘having’ clause and a ‘where’ clause?
How would you go about developing a ssrs report?
List out a number of the wants to setup a SQL Server failover cluster?
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
Explain about SQLOS?
How would we use distinct statement? What is its use?
Explain throw statement in sql server 2008?
Does the order of columns in update statements matter?
How to view existing indexes on an given table using sys.indexes?
What is model database? : SQL Server Architecture
How do you rebuild an identity column?
What are the differences between local and global temporary tables?