QQ网名大全

用sql语句生成数据库

oracle中的写法
WITH t1 AS ( --建立临时表
SELECT 1 AS L1,'A' AS L2, 'n' AS L3 FROM dual
UNION ALL
SELECT 2 AS L1,'A' AS L2, 'n' AS L3 FROM dual
UNION ALL
SELECT 3 AS L1,'A' AS L2, 'n' AS L3 FROM dual
UNION ALL
SELECT 4 AS L1,'B' AS L2, 'm' AS L3 FROM dual
UNION ALL
SELECT 5 AS L1,'B' AS L2, 'm' AS L3 FROM dual
UNION ALL
SELECT 6 AS L1,'B' AS L2, 'm' AS L3 FROM dual
)
SELECT t.*,
row_number() over(PARTITION BY t.L2 ORDER BY t.L1) row_ --按照规则排序
FROM t1 t;
你在oracle下试试看应该在嵌套一层就可以得出你想要的结果了!
佚名
2024-06-05 00:34:11
最佳回答
类似问题(10)