Select Top 1 * From (Select Top 5 * From Employee Order By 1 Asc) As X Or

how do we find every fifth record in a table

Question Posted / jahir

Answer Posted / jahir

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

Is This Answer Correct ?

8 Yes

2 No

Please Help Members By Posting Answers For Below Questions

List the different index configurations possible for a table?

934

How to drop an existing stored procedure in ms sql server?

1032

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1111

Explain transaction server implicit?

988

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

998

What is the chart in report?

158

Explain filestream storage of sql server 2008?

1020

what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration

994

Explain the ways to controlling cursor behavior?

919

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

1050

How do you identify a foreign key?

1030

What is read uncmmited?

1062

What is collation?

1144

What is normalization and denormalization in sql server?

1020

What is RAID? What are the different types of RAID configurations?

1136