用于批量创建的SQL查询 [英] SQL Query For Batch Creation

问题描述

你好，

我想为以下类型的记录创建批次.
想要以这种方式创建批次，它应该将RowID拆分为批次，但FamilyID不应跨批次拆分.

Hello,

I want to create batches for below kind of records.
Wanted To Create Batches In Such a way like, It should split RowID into Batches but FamilyID Should Not Split Across Batches.

+-------+----------+
| RowID | FamilyID |
+-------+----------+
|     1 |     2296 |
|     2 |     2242 |
|     3 |     2247 |
|     4 |     2243 |
|     5 |     2310 |
|     6 |     2310 |
|     7 |     2310 |
|     8 |     2310 |
|     9 |     2311 |
|    10 |     2311 |
+-------+----------+

+--------------+-------+
|    Batch     | Range |
+--------------+-------+
| Batch1       | 1-8   |
| Batch2       | 9-10  |
+--------------+-------+

注意:相同家庭的记录不应拆分为其他批次.

例如，上例中的2310单亲家庭记录应仅一批.
有什么帮助吗?如何为以上条件创建查询?

谢谢

Note: Records For Same Family Should Not Split To Other Batch.

i.e Single Family Record ex: 2310 in above example should be in one batch only.
Is there any help ? how can i create query for above criteria ?

Thanks

推荐答案

在这里看看:

这篇关于用于批量创建的SQL查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！