随机数
SELECT cast(RAND()*10000.10 AS DECIMAL(16,2)) FROM dual
序号
SELECT row_number() over(order by 【排序列】) FROM 【表】
分组序号
SELECT row_number() over(partition BY 【分组列】 order by 【排序列】) FROM 【表】
SELECT cast(RAND()*10000.10 AS DECIMAL(16,2)) FROM dual
SELECT row_number() over(order by 【排序列】) FROM 【表】
SELECT row_number() over(partition BY 【分组列】 order by 【排序列】) FROM 【表】