Select Top 1 * From (Select Top N * from tablename order by table.Colum

How to select nth record from a table?

Question Posted / pravin s. ahire

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

Please Help Members By Posting Answers For Below Questions

when you create a database how is it stored? : Sql server database administration

1082

Can sql server be linked with other servers like oracle?

1022

How to connect ms access to sql servers through odbc?

1069

Explain log shipping?

1076

What are dml triggers and types of dml triggers?

1028

How to restore performance issues and how to check?

2053

Why is normalisation important?

989

Explain foreign key in sql server?

1073

What are different backups available in sql server?

1153

What is Transparent Data Encryption?

1059

Explain the truncate command?

1037

What stored procedure can you use to display the current processes?

942

What happens if time-only values are provided as date and time literals?

1058

How to enable tcp/ip protocol on a sql server?

1212

How to delete existing triggers using "drop trigger"?

1098