with cte as( select ROW_NUMBER() over (order by id) as serial,* from tabl

how do we find every fifth record in a table

Question Posted / shanmugam

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

Please Help Members By Posting Answers For Below Questions

how many layers of tcp/ip protocol combined of? : Sql server database administration

956

How to concatenate two binary strings together?

1064

How to start and end transact-sql statements?

992

what is a transaction? : Sql server database administration

953

What is use of except clause? How does it differ from not in clause?

977

Why are sql functions used?

1069

What is “asynchronous” communication in sql server service broker?

978

Find first and last day of current month in sql server

999

How to get the definition of a view out of the sql server?

953

What is a scheduled job or what is a scheduled task?

922

What is raid, and how it can influence database performance?

1030

What is the concept of optimization?

999

Explain what is log shipping?

1087

What is checkpoint process in the sql server?

975

What is unpivot?

977