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

What happens if you add a new index to large table?

943

What are audit control procedures?

995

What is resource db in sql server?

1032

How to enable tcp/ip protocol on a sql server?

1170

what type of index will get created after executing the above statement? : Sql server database administration

977

Which trace flags are enabled in sql server?

1023

What do you mean by an execution plan? Why is it used? How would you view it?

932

How do you delete a trigger?

987

Does order by actually change the order of the data in the tables or does it just change the output?

1152

What happens if an integer is too big for int date type?

979

What is rank function?

1036

How do we synchronize On-Premise SQL server with SQL Azure?

122

How to create a large table with random data for index testing in ms sql server?

1033

How to execute a stored procedure in ms sql server?

1186

What is stored in the mssqlsystemresource database? : sql server database administration

1035