Interested to Buy Any Domain ? << Click Here >> for more details...
How to select nth record from a table?
- 13 Answers
- 41325 Views
- DELL, Microsoft, Ramco, I also Faced
- E-Mail Answers
Answer Posted / ravinder pawar
Hi Frnds,
Pravin's logic is correct. I am just modifying it little
bit.
Select Top 1 *
From (Select Top 5 *
from HumanResources.Employee
order by EmployeeID desc)as temp
---Note If we don't use temp we'll get error as mentioned
below:
Incorrect syntax near ')'.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Explain differences between web edition and business edition?
What are synonyms?
What is table valued function and scalar valued functions?
What is application role in sql server database security? : sql server security
explain different types of joins? : Sql server database administration
Mention the 3 ways to get a count of the number of records in a table.
Is t sql the same as sql server?
How to create an index on a view?
What is co-related sub query?
How can you append an identity column to a temporary table?
How do I create a stored procedure in sql server?
Explain a join?
What are the 7 disadvantages to a manual system?
what is database replicaion? : Sql server database administration
How do I edit a stored procedure in sql server?
