Interested to Buy Any Domain ? << Click Here >> for more details...
How to select nth record from a table?
- 13 Answers
- 40376 Views
- DELL, Microsoft, Ramco, I also Faced
- E-Mail Answers
Answer Posted / pravin s. ahire
Select Top 1 *
From (Select Top N * from tablename order by
table.ColumnName desc)
-- where N = nth record
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What are the different types of locks in the database?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
What are the properties and different types of sub-queries?
Which database stores information about replication?
Other than truncate statement, which other command can by-pass the trigger on the tables?
Does server sql treat char as a variable-length or fixed-length column?
What is query parameter in ssrs?
What is the maximum size of a row in sql server?
How many types of dimensions are there and what are they? : sql server analysis services, ssas
What do you understand by a view? What does the with check option clause for a view do?
What do you mean by a Composite primary key?
What are various aggregate functions that are available?
Why use sub query in sql server and list out types of sub queries?
What are the differences between char and nchar in ms sql server?
What do you understand by user-defined function in the sql server?
