how do we find every fifth record in a table
Answer Posted / divya mahendra sikarwar
Select Top 1 * From (Select Top 5 * From customer Order By
1 Desc) As X
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is subreport?
How to delete all rows with truncate table statement in ms sql server?
What is the sql profiler?
What is replication with database mirroring? : sql server database administration
Suggest a method of joining two tables.
What is dbcc updateusage?
how to avoid cursors? : Sql server database administration
What are system databases in ms sql server?
what is normalization? Explain different levels of normalization? : Sql server database administration
what data regions are and what are the different data regions?
What are different types of statement?
How to delete duplicate rows from table except one?
Explain the difference between cross join and full outer join?
What is difference between line feed ( ) and carriage return ( )?
What are the advantages of mirroring?