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

What is mscorsvw.exe - process - microsoft .net framework ngen?

921

Tell me what are cursors and when they are useful?

920

What are dml (data manipulation language) statements in ms sql server?

946

What are the different index configurations a table can have?

924

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

1002

What are the types of database schema? : sql server analysis services, ssas

1093

Explain about protocol layer present in SQL server?

1139

What are Spatial data types in SQL Server 2008

983

What are different types of statement?

966

Tell about MOM Tool(Microsoft Operator Manager)?

1873

Tell me when is the update_statistics command used?

1053

What is a subquery in a select query statement in ms sql server?

1090

What are the general features of sql server management studio? : sql server management studio

1042

Explain about sql server login?

1049

What are different type of Collation Sensitivity?

966