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 'write-ahead log' in sql server 2000 ?

1016

Why use view instead of a table?

904

How to change the system date and time from SQL Plus Terminal ?

1180

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

2022

A trigger can reference objects outside the current database? State true or false.

972

What is t-sql script to take database offline – take database online.

1040

what is sql server? : Sql server database administration

950

Explain comment on transactions?

954

What are the 7 disadvantages to a manual system?

936

How raid can influence database performance?

988

Do you know what are the ways available in sql server to execute sql statements?

990

How to see the event list of an existing trigger using sys.trigger_events?

1044

How to modify existing triggers using "alter trigger"?

963

Explain can you implement data mining in ssrs?

156

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

1056