how do we find every fifth record in a table
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 to insert and update data into a table with "insert" and "update" statements?
What is SQL Azure Firewall?
What is the Main Difference between ACCESS and SQL SERVER?
List out the differences between the clustered index and non-clustered index in sql server?
explain different types of backups avaialabe in sql server? : Sql server database administration
What are the advantages of policy management?
How to execute multiple stored procedures at one time in sql server?
What is sql server profiler?
How the authentication mode can be changed?
What is the use of =,==,=== operators?
What is the difference between NOROW and LOCKROW?
What are the characteristics of modern DBMS?
What is the name of reporting services config file and what’s it’s used for?
Define normalisation?
Differentiate between mongodb vs. Sql server?