Retrieve every n values

this scripts presents the way to retrieve from a given result set the values given n where n determines that the Nth value,2N th values , 3Nth value will be returnedin the example n = 3 the returning rows are 22,32,42the given set is 20,21,22,30,31,32,40,41,42

2002-08-01

427 reads

Blogs

How to Design Backups in SQL Server?

By

The Recovery Point Objective (RPO) and Recovery Time Objective (RTO) are basic concepts related...

Daily Coping 23 Sept 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Getting Up and Running with Dapr

By

I’ve heard about Dapr a few times from developer friends, but hadn’t really understood...

Read the latest Blogs

Forums

Hu?ng d?n tài li?u, ch?ng c? kh?i ki?n tranh ch?p d?t dai

By luatlongphanpmt

HU?NG D?N TÀI LI?U, CH?NG C? KH?I KI?N TRANH CH?P Ð?T ÐAI - LU?T...

The OPENJSON return schema

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The OPENJSON return schema

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers