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 read uncmmited?

1116

How to backup SQL Server Reporting Services ?

152

Are semicolons required at the end of sql statements in sql server 2005?

1038

What is sql server database?

1081

What is tempdb database? : SQL Server Architecture

1258

Explain about system database?

1110

What is the filtered index?

1110

Tell me what is the stuff and how does it differ from the replace function?

1035

How to rebuild master databse?

1128

How do you delete duplicate records in sql server?

1127

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1565

Explain what is cte (common table expression)?

1188

What is the process of indexing?

1053

What are the system database in sql server 2008?

1097

How many types of dimensions are there and what are they? : sql server analysis services, ssas

1120