我有以下疑问：

SELECT
    ROW_NUMBER() OVER(ORDER BY A.Price) AS R,
    A.Price
FROM 
    TableA A
INNER JOIN 
    TableB B ON A.ID = B.ID
INNER JOIN 
    TableC C ON C.Code = A.Code
WHERE
    C.Type = 125
    AND A.Desc = 10000038
    AND C.YearID = 10000021
GROUP BY 
    A.Price

此查询返回
| 右|价格|
| - ------| - ------|
| 1个|一百六十五|
| 第二章|四八七|
| 三个|小行星1807|
是否可以在一次选择中分配变量@a = 165、@b = 487和@c = 1807？
我写了这个查询：

WITH P AS (
SELECT
    ROW_NUMBER() OVER(ORDER BY A.Price) AS R,
    A.Price
FROM 
    TableA A
INNER JOIN 
    TableB B ON A.ID = B.ID
INNER JOIN 
    TableC C ON C.Code = A.Code
WHERE
    C.Type = 125
    AND A.Desc = 10000038
    AND C.YearID = 10000021
GROUP BY 
    A.Price
)
SELECT
    @a = (CASE WHEN [R] = 1 THEN P.[Price] END),
    @b = (CASE WHEN [R] = 2 THEN P.[Price] END),
    @c = (CASE WHEN [R] = 3 THEN P.[Price] END)
FROM P;

但是只有@c得到这个值。