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

Can you move the resources after pausing the node? : sql server database administration

582

Explain the collation?

614

define and explain the differences between clustered and non-clustered indexes.

585

What is the use of stored procedure?

505

How to get the number of affected rows?

548

You want to implement the many-to-many relationship while designing tables. How would you do it?

547

What are sql azure firewall rules?

Do you know what is openxml in sql server?

607

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

519

What are transactions in sql?

536

What is analysis service repository?

576

What is the difference between mysql and sql server?

462

What are relationships and mention different types of relationships in the dbms

544

Where do you find the default Index fill factor and how to change it?

591

What does asynchronous call backs means?

613