SELECT employeeID from ( Select ROW_NUMBER() OVER ( order by id )as RowNumb

how do we find every fifth record in a table

Question Posted / avinash

Answer Posted / avinash

SELECT employeeID from ( Select ROW_NUMBER() OVER ( order by id )as RowNumber,employeeID FROM Employee ) as x where x.RowNumber % 5 = 0

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to update muliple row in single query?

1069

What is the New in SQL server 2008?

982

What are the differences between web role and worker role?

122

Indexes are updated automatically is the full-text index also updated automatically?

1034

What does it mean to invest in the index?

979

What is report rendering ?

162

how to determine the service pack currently installed on sql server? : Sql server database administration

979

Explain the steps needed to create a scheduled job?

944

What is cte (common table expression)?

1042

What are the restrictions that views have to follow? : SQL Server Architecture

1009

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

975

What do you mean by collation recursive stored procedure?

1067

What are policy management terms?

992

How would you choose between a clustered and a non-clustered index?

982

What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

1025