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 is trigger in salesforce?

1054

How do I connect to sql server database?

1068

What are commonly used odbc functions in php?

1059

What are the results of running this script?

975

What structure can you implement for the database to speed up table reads?

1236

How to change the password of a login name in ms sql server?

1059

What is a collation in ms sql server?

1136

What is bit data type? What's the information that can be stored inside a bit column?

969

What is the default schema of your login session in ms sql server?

1093

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

2011

How to name query output columns in ms sql server?

1015

What are partitioned views?

1053

Define compound operators?

969

What is stretch database in sql server?

1120

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

1120