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
Where are sql server user names and passwords stored in sql server?
How to define and use table alias names in ms sql server?
What is de-normalization in sql database administration? Give examples?
What is deploy, process and build? : sql server analysis services, ssas
What are the differences between sql server and mysql.
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?
How to use subqueries with the in operators in ms sql server?
What is a result set object returned by odbc_exec()?
Where cross join is used?
Will count(column) include columns with null values in its count?
What is a derived table?
explain databases and sql server databases architecture? : Sql server database administration
what are isolation levels? : Sql server database administration
In which tcp/ip port does sql server run? Can it be changed?
What is onf in normalization form?