SELECT
NEXT VALUE FOR getKNO
FROM
table
ORDER BY
name
执行报错,调查发现,NEXT VALUE FOR和order by会起冲突
NEXT VALUE FOR [ database_name . ] [ schema_name . ] sequence_name
[ OVER (<over_order_by_clause>) ]
代码修改为
SELECT
NEXT VALUE FOR getKNO OVER (
ORDER BY
name
)
FROM
table
ORDER BY
name
执行成功