内容摘要:复制WITHtAS (SELECT1StuID,70Score UNIONALL SELECT2,85 UNIO

复制WITH t AS (SELECT 1 StuID,聊聊
70 Score UNIONALL SELECT 2,85 UNIONALL SELECT 3,85 UNIONALL SELECT 4,80 UNIONALL SELECT 5,74 ) SELECT * INTO Scores FROM t; SELECT * FROM Scores 1.2.3.4.5.6.7.8.9.10.11.12.13.