how do we find every fifth record in a table
Answer Posted / jahir
Select Top 1 * From (Select Top 5 * From Employee Order By
1 Asc) As X Order By 1 Desc
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
List the different index configurations possible for a table?
How to drop an existing stored procedure in ms sql server?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
Explain transaction server implicit?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
What is the chart in report?
Explain filestream storage of sql server 2008?
what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration
Explain the ways to controlling cursor behavior?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
How do you identify a foreign key?
What is read uncmmited?
What is collation?
What is normalization and denormalization in sql server?
What is RAID? What are the different types of RAID configurations?