墓型价格分析表

最新推荐文章于 2025-06-09 17:23:19 发布

转载最新推荐文章于 2025-06-09 17:23:19 发布 · 95 阅读

本文介绍了一个复杂的SQL查询案例，展示了如何从多个表中选择并汇总数据。通过此案例，读者可以了解到如何使用SQL进行高级的数据筛选与聚合操作。

 SELECT t1.azfsmc AS AZFS,
            MIN (TO_CHAR (t1.rq, 'yyyy')) AS nd,
            t1.mxmc,
            t1.mj,
            MIN (t1.ssje) AS zx,
            MAX (t1.ssje) AS zd,
            TRUNC (AVG (t1.ssje), 2) AS pjz,
            COUNT (*) AS sl,
            SUM ((SELECT SUM (ssje)
                      FROM ywdjb
                     WHERE zxflag <> '1')
                 - (SELECT SUM (ssje)
                      FROM ywdjb
                     WHERE zxflag = '2'))
               AS sr,
         (SELECT LYID FROM lyxxb) AS DWDM
       FROM ywdjb t1, azfs t2
      WHERE     t1.azfsdm = t2.azfsdm
            AND (t2.stazbz = '1' OR t2.ltazbz = '1')
            AND t1.zxflag <> '1'
   GROUP BY t1.azfsmc,
            t2.nx,
            t1.mxmc,
            t1.mj;