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 to retrieve error messages using odbc_errormsg()?

1058

How will you optimize a stored procedure optimization?

1040

Write a sql query to sort on different column name according to the parameters passed in the function?

904

What is the sql server agent?

1088

What is the use of nvl work?

1004

How to list all field names in the result set using mssql_field_name()?

914

How to execute stored procedure and set temp table in sql server?

1040

How to set database to be single_user in ms sql server?

1029

What is the default fill factor value?

1080

How to delete an existing row with delete statements in ms sql server?

1093

What are page splits? : SQL Server Architecture

989

What is sql server query analyzer?

1030

What it means to be triggered?

1008

What is Sqlpaging in SqlServer 2005 ?

1065

What is the difference between functions and stored procedures?

1161