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

What are pages and extents? : SQL Server Architecture

1072

What is triggers in ms sql server?

1181

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

1045

If the job running very slow what is the action you do

1942

What are the benefits of filtered indexes?

1096

What is bcp? When does it used?

1044

What is Replication?

1108

What is the use of =,==,=== operators?

1058

What is dbcc updateusage?

1257

How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

1151

What is the difference between dropping a database and taking a database offline?

1218

What is the data type of time?

1017

tell me what is blocking and how would you troubleshoot it? : Sql server database administration

944

How to delete database objects with "drop" statements in ms sql server?

1152

What is plan freezing?

1014