![](https://img-blog.csdnimg.cn/20201014180756926.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle
我要吃雪糕
菜鸟成长记
展开
-
Oracle11.2新特性之listagg函数 (行列转换)
SELECT name, LISTAGG(ename, ',') WITHIN GROUP(ORDER BY ename) ASenames FROM class GROUP BYname;原创 2017-03-26 22:19:01 · 481 阅读 · 0 评论 -
decode函数,wm_concat,nvl,group by综合使用
select b.part_no,b.serial_number,wm_concat(b.ifxd) IF_REDfrom (select decode(sign(nvl(c.remove_qty, 0) - nvl(c.return_qty, 0)),0,0,1) ifxd, d.*from MM_ZCJ_BASE_INFO d left join MM_ZCJ_DETAIL ...原创 2018-08-22 00:21:11 · 1204 阅读 · 0 评论