筛选表并添加顺序以生成SQL

Question

让我们假设我有一个如下表：

<1.2><1.1><1.5>

区域	ID	值
A	1	0.5
A	2
B	3
B	4	0.8
C	5	1.0
B	6	0.6
A	7

您需要的是ROW_NUMBER((函数。

SELECT Area
, ROW_NUMBER() OVER (PARTITION BY Area ORDER BY ID) AS Order
, Value 
FROM YourTable 
WHERE Area = 'B' -- You can try without where, you'll get order by each area