Interested to Buy Any Domain ? << Click Here >> for more details...
can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
- 28 Answers
- 31692 Views
- IBM, Symphony, I also Faced
- E-Mail Answers
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
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
explain databases and sql server databases architecture? : Sql server database administration
How can I create a new template for import ? : sql server management studio
What is CTE in SQL
Why the trigger fires multiple times in single login?
What are the differences between union, intersect, and minus operators?
Can we write trigger for view?
How would you choose between a clustered and a non-clustered index?
Explain filtered indexes?
How to edit table in sql server 2017?
How will you monitor replication latency in transactional replication? : sql server replication
How to list all triggers in the database with sys.triggers in ms sql server?
What is log ldf?
What are the advantages of user defined function?
What are the dmvs?
