SQL 查询 - 重复结果 5 次，并删除结果集的每个信誉的第一行

Question

我当前的数据集

+----+-------+
| ID | Value |
+----+-------+
| 1  | 40    |
+----+-------+
| 2  | 20    |
+----+-------+
| 3  | 30    |
+----+-------+
| 4  | 60    |
+----+-------+
| 5  | 10    |
+----+-------+

例外输出：

+--------+----+-------+
| Row_ID | ID | Value |
+--------+----+-------+
| 1      | 1  | 40    |
+--------+----+-------+
| 1      | 2  | 20    |
+--------+----+-------+
| 1      | 3  | 30    |
+--------+----+-------+
| 1      | 4  | 60    |
+--------+----+-------+
| 1      | 5  | 10    |
+--------+----+-------+
| 2      | 2  | 20    |
+--------+----+-------+
| 2      | 3  | 30    |
+--------+----+-------+
| 2      | 4  | 60    |
+--------+----+-------+
| 2      | 5  | 10    |
+--------+----+-------+
| 3      | 3  | 30    |
+--------+----+-------+
| 3      | 4  | 60    |
+--------+----+-------+
| 3      | 5  | 10    |
+--------+----+-------+
| 4      | 4  | 60    |
+--------+----+-------+
| 4      | 5  | 10    |
+--------+----+-------+
| 5      | 5  | 10    |
+--------+----+-------+

Answer 1

你似乎想要一个自我加入：

select t.id, t2.id, t2.value
from t join
t t2
on t.id <= t2.id;