how do we find every fifth record in a table
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 |
Post New Answer View All Answers
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
List the different types of collation sensitivities in sql server?
What are the differences between char and nchar in ms sql server?
What is stretch database in sql server?
Explain the difference between functions and stored procedures in sql server?
What are the advantages of partitioning?
What do you understand by coalesce in sql server?
What are the different types of Indexes available in SQL Server?
How many types of local tables are there in sql server?
How many null values we can have in a unique key field in sql server?
How to optimize stored procedure optimization?
Explain the steps to use transact-sql cursor?
Do you know what is lock escalation?
How many replicas are maintained for each sql azure db?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?