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


Please Help Members By Posting Answers For Below Questions

What is subreport?

96


How to delete all rows with truncate table statement in ms sql server?

490


What is the sql profiler?

542


What is replication with database mirroring? : sql server database administration

529


Suggest a method of joining two tables.

601






What is dbcc updateusage?

534


how to avoid cursors? : Sql server database administration

493


What are system databases in ms sql server?

535


what is normalization? Explain different levels of normalization? : Sql server database administration

651


what data regions are and what are the different data regions?

101


What are different types of statement?

523


How to delete duplicate rows from table except one?

543


Explain the difference between cross join and full outer join?

497


What is difference between line feed ( ) and carriage return ( )?

522


What are the advantages of mirroring?

571