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

What is key set driven?

950

Explain about system stored procedure?

1030

What are the steps to insert a table?

943

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

941

Can you explain what are commit and rollback in sql?

934

How to get a list all databases on the sql server?

1094

Is it possible for a stored procedure to call itself or recursive stored procedure?

946

Explain what is dbcc?

1003

What's the information that can be stored inside a bit column?

996

how can a database be repaired? : Sql server administration

967

What is the name of reporting services config file and what’s it’s used for?

146

What are trace flags?

1028

Difference between DELETE and TRUNCATE?

1047

How to get a list of columns using the "sys.columns" view in ms sql server?

954

What is use of except clause?

1092