Interested to Buy Any Domain ? << Click Here >> for more details...
how to retrive only second row from table in sql server
2000?
- 15 Answers
- 26577 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
What is exclusive locks?
how would you troubleshoot blocking? : Sql server database administration
Can we use pragma autonomous_transaction in trigger?
What is a transaction and why is it important?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
Explain features and concepts of analysis services?
What is sql language?
How sql server enhances scalability of the database system?
what are the important architecture components of SSRS?
Tell me about normalization in DBMS.
How to list all objects in a given schema?
explain different types of joins? : Sql server database administration
What causes index fragmentation?
What is the main purpose of having conversation group?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
