![](https://img-blog.csdnimg.cn/20201014180756754.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库
青出于蓝而胜于蓝
这个作者很懒,什么都没留下…
展开
-
oracle查询同比语句
CREATE OR REPLACE VIEW F_WLAQYS_VW AS select CC.DATEKEY,CC.XMLX,CC.ORG_ID,CC.BNYSED,CC.BNZXED,CC.QNYSED,CC.QNZXED, NVL(ROUND(CC.BNZXED / CC.QNZXED - 1, 4) * 100, 0) AS ZXETB from (SELECT AA.DATEKEY,AA.XMLX,AA.ORG_ID,AA.YSED AS BNYSED,AA.ZXED AS B...原创 2021-11-22 14:30:16 · 366 阅读 · 0 评论 -
oracle行转列、列转行查询语句
1、行转列 select * from (select A.datekey, A.Dateyear,A.Datemonth from F_JZB_WLAQXMSL A) pivot (sum(A.XMSL) for A.XMJD in ('1' 规划, '2'立项, '3'建设, '4'验收,'5'结项,'6'运维)); 2、列转行 SELECT * FROM F_JZB_GYSPPM UNPIVOT( "NIANYUE " FOR"项目" IN ( Dppmzb, Tlzs, Zxbls, Llbl原创 2021-11-22 14:28:12 · 988 阅读 · 0 评论