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

Where are sql server user names and passwords stored in sql server?

1039

How to define and use table alias names in ms sql server?

1076

What is de-normalization in sql database administration? Give examples?

944

What is deploy, process and build? : sql server analysis services, ssas

1057

What are the differences between sql server and mysql.

1052

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

910

How to use subqueries with the in operators in ms sql server?

1031

What is a result set object returned by odbc_exec()?

986

Where cross join is used?

918

Will count(column) include columns with null values in its count?

1053

What is a derived table?

889

explain databases and sql server databases architecture? : Sql server database administration

926

what are isolation levels? : Sql server database administration

937

In which tcp/ip port does sql server run? Can it be changed?

959

What is onf in normalization form?

1018