Select Top 1 * From (Select Top 5 * From customers Order By 1 Asc) X Orde

how do we find every fifth record in a table

Question Posted / srivatsa p

Answer Posted / srivatsa p

Select Top 1 * From (Select Top 5 * From customers Order By
1 Asc) X Order By 1 Desc

Is This Answer Correct ?

4 Yes

4 No

Please Help Members By Posting Answers For Below Questions

How do I view a procedure in sql server?

999

Explain the categories of stored procedure?

940

What are the drawbacks of reporting in ssrs?

151

How to get the definition of a view out of the sql server?

990

How to enforce security in sql server? : sql server security

1115

What is code near application topology?

279

Do you know data definition language, data control language and data manipulation language?

1046

How to set database to be single_user in ms sql server?

1042

How to retrieve error messages using odbc_errormsg()?

1068

Explain the usage of floor function in sql server.

971

What is the difference between primary key and unique constraints?

971

Tell me when is the update_statistics command used?

1125

Explain the flow of creating a cube? : sql server analysis services, ssas

1062

Can we insert data into view sql server?

941

How to list all schemas in a database?

1069