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 index views?

903

How to create sub reports?

245

What are the system database in sql server 2008?

1042

How many types of schemas are there?

1051

What are cursors and when they are useful?

1101

What is the datatype of rowid?

936

Tell me something about security and sql azure?

114

explain declarative management framework (dmf) in sql server 2008?

1004

How to attach adventureworkslt physical files to the server?

1113

What are ddl triggers and types of ddl trigger?

1046

Explain the creation and execution of a user-defined function in the sql server?

1059

What is ssl in sql server?

1090

What is the full meaning of dml?

958

How to divide query output into multiple groups with the group by clause in ms sql server?

1053

Why are you getting errors when creating a new odbc dsn?

1234