Select Top 1 * From (Select Top 5 * From customer Order By 1 Desc) As X

how do we find every fifth record in a table

Question Posted / divya mahendra sikarwar

Answer Posted / divya mahendra sikarwar

Select Top 1 * From (Select Top 5 * From customer Order By
1 Desc) As X

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Can you force a query to use a specific index?

906

What method is used by the Command classes to execute SQL statements that return single values?

1026

What are the new features are introduced in sql server 2012 reporting services?

147

What is query optimizer in sql server?

976

What are the different types of stored procedures?

1083

How to insert stored procedure result into temporary table?

991

What do you mean by normalisation?

989

What are the encryption mechanisms in sql server?

981

What are different types of data sources?

957

please differentiate between delete and truncate?

955

Do you know what is xpath?

1026

Can foreign key be duplicate?

1018

You want to use a perspective in an mdx query. How do you select the perspective?

237

Can two tables share a primary key?

969

What are the results of running this script?

882