Select every Nth row from a table

[plzansmyquery]

Hi all,

please help me in writing a query for selecting every Nth row in a table.

Thank you in advance

[amitpatel66]

Hi all,

please help me in writing a query for selecting every Nth row in a table.

Thank you in advance

Could you please post your table structure here and what you have tried so far?

[deepuv04]

Could you please post your table structure here and what you have tried so far?

Hi,
try the following query to get nth record

 
SELECT * From (SELECT  *,(Dense_Rank() Over (Order By Column_Name Desc)) As Rank 
From Table_Name) As Z Where Rank=3
 
 

[plzansmyquery]

Hello deepuv04

Thank you for the reply. But this query gives only the nth record in table, but I want every Nth row (ex: 10th, 20th, 30th....) in the table. Can we do that?

[deepuv04]

Hello deepuv04

Thank you for the reply. But this query gives only the nth record in table, but I want every Nth row (ex: 10th, 20th, 30th....) in the table. Can we do that?

hi,
we can do that. pass the ranks as varchar comma seperated

eg: @Rank as '10,20,30'

use the following query, it will give you the ranks you specified, if @Rank is null the will give you all the records

      SELECT * FROM (SELECT  *,(Dense_Rank() Over (ORDER BY Column_Name DESC)) AS Rank
      FROM Table_Name) AS Z 
      WHERE     (','+isnull(@Rank,convert(varchar(10),Z.Rank)  )+',') like 
             ('%,'+convert(varchar(20),Z.Rank)+ ',%')))
 
 

[plzansmyquery]

Thank you ..I will try this..