Interested to Buy Any Domain ? << Click Here >> for more details...
how do we find every fifth record in a table
- 14 Answers
- 19194 Views
- Aspire, HCL, I also Faced
- E-Mail Answers
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 dml command?
Is foreign key a primary key?
How do I get to sql server configuration manager?
Explain how you can deploy an SSRS report?
What are the differences between union, intersect, and minus operators?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
How to find the list of fixed hard drive and free space on server?
Explain different forms of normalization?
How to create a user to access a database in ms sql server using "create user" statements?
Do you know how to make remote connection in database?
What is pivot and unpivot?
What is transaction server explicit transaction?
Write SQL queries on Self Join and Inner Join.
How does index makes search faster?
How do I find sql server instance name?
