how do we find every fifth record in a table
Answer Posted / shanmugam
with cte as(
select ROW_NUMBER() over (order by id) as serial,* from tablename
)
select * from cte where serial=5
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Which autogrowth database setting is good?
Name and describe few console utilities for ssrs?
What is transaction server consistency?
Introduction of rollup clause using sum and group by clause?
What is the difference between rank and dense_rank?
Explain about service Broker functions?
How to list all schemas in a database?
Explain active/passive and active/active cluster configurations?
what stored procedure would you use to view lock information? : Sql server administration
What is the purpose of sql profiler in sql server? : sql server database administration
How do you delete a data source?
What is importing utility?
What is user-defined function?
what is the sql equivaent of the dataset relation object ?
What command would you use to create an index?