how do we find every fifth record in a table
- 14 Answers
- 15377 Views
- Aspire, HCL, I also Faced
- E-Mail Answers
Answer Posted / srivatsa p
Select Top 1 * From (Select Top 5 * From customers Order By
1 Asc) X Order By 1 Desc
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
How do you size a resultset?
How to convert a numeric expression from one data type to another?
Do you know data definition language, data control language and data manipulation language?
How to create a user to access a database in ms sql server using "create user" statements?
Would you store your query in a ssrs report or a database server? State the reason why?
How many categories of functions based their return modes?
What do you mean by sql server agent?
When would you use a before or after trigger?
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
Define candidate key, alternate key, and composite key.
Does the unique constraint create an index?
How can you ensure that the database and sql server based application perform well?
Differentiate between delete and truncate.
What is wide table?
What is the difference between implicit and explicit transaction?
