sql - 为 postgreSQL 查询结果添加索引

Question

我的查询结果是这样的:

| A | B |
|-------|
| 1 | 2 |
| 1 | 4 |
| 1 | 6 |
| 1 | 9 |
| 1 | 1 |
| 1 | 6 |
| 1 | 9 |

现在我想将结果表的索引增加A列，所以结果会变成这样:

| A | B |
|-------|
| 2 | 2 |
| 3 | 4 |
| 4 | 6 |
| 5 | 9 |
| 6 | 1 |
| 7 | 6 |
| 8 | 9 |

我该怎么做？谢谢!

Answer 1

你想要row_number()

select (row_number() over (order by a) + 1) as A, b
from table t;