how to retrive only second row from table in sql server
2000?
- 15 Answers
- 22484 Views
- Cognizant, CTS, I also Faced
- E-Mail Answers
Answer Posted / belson gnana pradeep
SELECT TOP 1 salary FROM
(SELECT DISTINCT TOP 2 salary FROM employee
ORDER BY salary DESC) a ORDER BY salary
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What Is Rdbms?
Can select statements be used on views in ms sql server?
What is the purpose of the tempdb database?
Why do we need normalization?
What are the advantages of mirroring?
How to drop an existing schema in ms sql server?
How many cores do I need for sql server 2016?
Explain timestamp datatype?
What do you mean by normalisation?
How do I find the size of a sql server database?
Describe and explain about SQL native client?
explain different types of joins? : Sql server database administration
What is key set driven?
What are the different types of backups that exist?
