how do we find every fifth record in a table
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 |
Post New Answer View All Answers
What is the difference between clustered and non-clustered indexes in ms sql server?
can a table be moved to different filegroup? : Sql server administration
What are temporal tables in sql server 2016?
Explain what is the function of sql server agent windows service?
Tell me something about security and sql azure?
Explain trigger and trigger types?
What do you understand by the denormalisation?
How to use wildcard characters in like operations in ms sql server?
What is query cost in sql server?
What are tables in sql server?
What is unique key constraint?
How to list all schemas in a database?
How to get @@error and @@rowcount at the same time?
What is the difference between online clustering and Offline clustering?
what are the Prerequisites for Replication?