專題文章
時(shí)長(zhǎng):00:00更新時(shí)間:2020-11-09 07:30:56
oracle多列轉(zhuǎn)成一列(列轉(zhuǎn)行)、行轉(zhuǎn)列:1. 多列轉(zhuǎn)成一列(列轉(zhuǎn)行) -- 6列轉(zhuǎn)成兩列(列轉(zhuǎn)行) 這就是最常見(jiàn)的列轉(zhuǎn)行,主要原理是利用SQL里面的union with temp as (select a.iid_sn, a.product_name, a.sales_figures, a.selling_cost, a.pretax_profit, a.cl
查看詳情