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

What is a domain constraint give an example?

1016

What is the difference between char, varchar and nvarchar?

997

How to find tables without indexes?

1056

Explain the properties of a relational table?

990

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

945

How to integrate the ssrs reports in application?

955

What is merge?

967

what stored procedure would you use to view lock information? : Sql server administration

937

What is CTE in SQL

901

What are the different types of collation sensitivity in sql server?

1062

Can we call stored procedure in view in sql server?

876

What are the different types of Indexes available in SQL Server?

970

Does group by sort data?

859

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

1965

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

1003