SQL Server 如何将 a,b,c,d行模式变成一列(只有一行)?只有20分全部捐出...答:或者不用pl/sql,利用分析函数和 CONNECT_BY 实现:SELECT c1, SUBSTR (MAX (SYS_CONNECT_BY_PATH (c2, ';')), 2) NAME FROM (SELECT c1, c2, rn, LEAD (rn) OVER (PARTITION BY c1 ORDER BY rn) rn1 FROM (SELECT c1, c2, ROW_NUMBER () OVER (ORDER BY c2) rn FRO...