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 is log ldf?

553

Mention the command used to rename the database.

534

What are the 2 types of classifications of constraints in the sql server?

584

Why is sql server log file full?

535

Explain the usage of floor function in sql server.

502

How to use union to merge outputs from two queries together in ms sql server?

556

How the authentication mode can be changed?

604

What are the difficulties faced in cube development? : sql server analysis services, ssas

607

What are the advantages to use stored procedures?

570

Do you know how to make remote connection in database?

550

How many triggers you can have on a table?

531

Explain magic tables in sql server?

548

What happens if null values are involved in bitwise operations?

603

Explain the first normal form(1nf)?

558

Can two tables share a primary key?

514