WITH numbered_rows AS (
SELECT
*,
ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS row_num
FROM original_table) --第一步增加一个序号
SELECT CASE WHEN row_num = 1 THEN '第一个'
WHEN row_num = 2 THEN '第二个'
WHEN row_num = 3 THEN '第三个'
END
FROM numbered_rows; --用case when 转换一下