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 are alternate keys?
What is row_number function?
What is temporal data type?
Explain what is “asynchronous” communication in sql server service broker?
Explain indexed views and partitioned view with their syntax.
What is conditional split?
What are the restrictions that views have to follow?
How do you debug a procedure in sql server?
Explain insert into select statement?
Does server sql treat char as a variable-length or fixed-length column?
What is set nocount on and what is set nocount off?
When multiple after triggers are attached to sql table, how to control the order of execution?
can a table be moved to different filegroup? : Sql server administration
Why do we need different type of parameter?
Which rendering formats are affected by the pagesize properties?