晒晒我的sql语句，请求指点

最新推荐文章于 2023-02-09 22:05:06 发布

转载最新推荐文章于 2023-02-09 22:05:06 发布 · 64 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/137913828S2/archive/2012/08/07/s2.html

本文探讨了如何使用SQL查询和聚合分析来提取历史数据集的关键信息，包括日期序列、事件频率和时间趋势。通过详细的SQL语句示例，展示了如何对特定字段进行分组、聚合和比较，以揭示数据背后的故事。

select t5.v01000,
       (select avg(seq)
          from (select t.*,
                       to_char(to_char(t.event_date, 'DDD'), '999') as seq
                  from T_LTCD_FROSTY_HIST t) t8
         where t8.v01000 = t5.v01000
         group by t8.v01000),
       t5.v04002 || '-' || t5.v04003,
       t6.v04002 || '-' || t6.v04003,
       (select avg(seq) -
               (select avg(seq)
                  from (select t.*,
                               to_char(to_char(t.event_date, 'DDD'), '999') as seq
                          from T_LTCD_FROSTY_HIST t) t8
                 where t8.v01000 = t7.v01000
                 group by t8.v01000)
          from (select t.*,
                       to_char(to_char(t.event_date, 'DDD'), '999') as seq
                  from T_LTCD_FROSTY_HIST t) t7
         where t7.v01000 = t5.v01000
         group by t7.v01000)
from (select distinct t2.v01000 as v01000, t2.v04002, t2.v04003
          from (select t.*,
                       to_char(to_char(t.event_date, 'DDD'), '999') as seq
                  from T_LTCD_FROSTY_HIST t) t2
         where t2.seq in
               (select max(t1.seq)
                  from (select t.*,
                               to_char(to_char(t.event_date, 'DDD'), '999') as seq
                          from T_LTCD_FROSTY_HIST t) t1
                 group by t1.v01000)) t5
left join (select distinct t3.v01000 as v01000, t3.v04002, t3.v04003
               from (select t.*,
                            to_char(to_char(t.event_date, 'DDD'), '999') as seq
                       from T_LTCD_FROSTY_HIST t) t3
              where t3.seq in
                    (select min(t4.seq)
                       from (select t.*,
                                    to_char(to_char(t.event_date, 'DDD'),
                                            '999') as seq
                               from T_LTCD_FROSTY_HIST t) t4
                      group by t4.v01000)) t6
    on t5.v01000 = t6.v01000

转载于:https://www.cnblogs.com/137913828S2/archive/2012/08/07/s2.html