將多行數(shù)據(jù)合并為一行 SQL將兩列的數(shù)據(jù)合并在一列？
SQL將兩列的數(shù)據(jù)合并在一列？兩列的數(shù)據(jù)類型要一樣select xx as zz from 表union select yy as zz from 表SQL如何將查詢結(jié)果合并成一行數(shù)據(jù)。在這個(gè)查詢語句
SQL將兩列的數(shù)據(jù)合并在一列？
兩列的數(shù)據(jù)類型要一樣
select xx as zz from 表
union
select yy as zz from 表
SQL如何將查詢結(jié)果合并成一行數(shù)據(jù)。在這個(gè)查詢語句前應(yīng)該如何處理？
for c in(select * from k_t) loop insert into k_t_tmp select 1，1，1，1，null from dual update k_t_tmp set k_n5=k_n5||c.k_n5 commit end loop