Interested to Buy Any Domain ? << Click Here >> for more details...
how do we find every fifth record in a table
- 14 Answers
- 18277 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 are the basic functions for master, msdb, model, tempdb and resource databases?
How to find related tables in sql server?
Mention the command used to rename the database.
What is policy management?
Why truncate is ddl?
What are the differences between clustered and non-clustered index?
What extended events?
What are the types of subquery?
What is code near application topology?
Explain the rules for designing files and file groups in sql server?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
Explain about system database?
How to delete database objects with "drop" statements in ms sql server?
What are the main differences between #temp tables and @table variables and which one is preferred?
if no size is defined while creating the database, what size will the database have? : Sql server administration
