SELECT RowNumber from ( Select ROW_NUMBER() OVER (order by EmployeeID)as

how do we find every fifth record in a table

Question Posted / krishans

Answer Posted / krishans

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

Is This Answer Correct ?

9 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is function of CUBE ?

1077

How fixed length strings are truncated and padded?

1023

How can you control the amount of free space in your index pages?

1101

What are statistics?

1051

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

1059

Write a program to fetch first 10 records from a file?

1063

How to execute a stored procedure in ms sql server?

1252

What is #table in sql server?

1098

Do you know what are acid properties of transaction?

1005

what is the difference between Tabular and Matrix report?

179

What is indexing and its types?

1057

How to provide values to user defined function parameters?

1062

Can select statements be used on views in ms sql server?

1112

Does sql server 2000 full-text search support clustering?

915

What are the common performance issues in sql server?

973