how do we find every fifth record in a table
- 14 Answers
- 15438 Views
- Aspire, HCL, I also Faced
- E-Mail Answers
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
What is the maximum row of a size?
Explain the phases a transaction has to undergo?
How do you drop an index?
What is rs.exe utility?
When you should use a low fill factor?
Why should we go for stored procedures? Why not direct queries?
Is it possible to replicate data from sql server to oracle? : sql server replication
What is difference between group by and having?
What are the different types of triggers in SQL SERVER?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
What is the cartesian product of table?
What are the system database in sql server 2008?
Write down the syntax and an example for create, rename and delete index?
Explain how dts is used to extract, transform and consolidate data?
When is update_statistics command used?
