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

How to enable/disable indexes?

1016

Difference between Logical Page and Physical Page in SSRS.

459

How do use Having,Group by,Group function in SQL?

1693

How to delete a login name in ms sql server?

1005

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

974

How many types of built in functions are there in sql server 2012?

876

How to get the definition of a view out of the sql server?

942

Explain DBCC?

911

What do you understand by integration services in sql server?

922

What are the different subsets of sql?

1473

What happens if null values are involved in bitwise operations?

967

What is Extended user-defined?

898

Explain triggers?

945

List out what other servers you can use with ssrs?

130

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

1011