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

Explain the disadvantages/limitation of the cursor?

917

What are the properties of the transactions?

1055

How to create a simple user defined function in ms sql server?

971

Explain what is cte (common table expression)?

1069

Explain transaction server implicit?

925

Explain few examples of RDBMS?

977

when you create a database how is it stored? : Sql server database administration

944

Explain error and transaction handling in sql server?

956

Explain the concept of recursive stored procedure.

885

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

1014

How do triggers work?

882

When cursors are useful?

1038

Describe in brief system database.

952

Give an example of SQL injection attack ?

932

How do I create a stored procedure in sql server?

965