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
[code=sql]

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

[/code]

[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

[code=sql]
SELECT * FROM (SELECT *,(Dense_Rank() Over (ORDER BY Column_Name DESC)) AS Rank
FROM Table_Name) AS Z
WHERE (','+isnull(@Ra nk,convert(varc har(10),Z.Rank) )+',') like
('%,'+convert(v archar(20),Z.Ra nk)+ ',%')))

[/code]

[plzansmyquery]

Thank you ..I will try this..