How to select nth record from a table?
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
when you create a database how is it stored? : Sql server database administration
Can sql server be linked with other servers like oracle?
How to connect ms access to sql servers through odbc?
Explain log shipping?
What are dml triggers and types of dml triggers?
How to restore performance issues and how to check?
Why is normalisation important?
Explain foreign key in sql server?
What are different backups available in sql server?
What is Transparent Data Encryption?
Explain the truncate command?
What stored procedure can you use to display the current processes?
What happens if time-only values are provided as date and time literals?
How to enable tcp/ip protocol on a sql server?
How to delete existing triggers using "drop trigger"?