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

Write a sql query to sort on different column name according to the parameters passed in the function?

855

How many partitions a clustered index has by default in sql server 2012?

1053

What are the main differences between #temp tables and @table variables and which one is preferred?

1015

How will you make an attribute not process? : sql server analysis services, ssas

1011

What stored by the master? : sql server database administration

1030

What is a transact-sql statement?

981

How can you stop stored procedures from recompiling?

849

How to get the number of affected rows?

952

What is the recovery model?

932

You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

116

What is cte (common table expression)?

979

Write a SQL query to make a column as unique?

963

How do I open a .db file?

974

What is tablix?

154

Explain about sql server login?

1029