一个超长SQL语句的规范书写格式范例.

最新推荐文章于 2025-06-12 11:58:35 发布

转载最新推荐文章于 2025-06-12 11:58:35 发布 · 2.1k 阅读

文章标签：

#sql #sql语句 #书写规范

sql 专栏收录该内容

3 篇文章

订阅专栏

本文提供了一段复杂的SQL查询代码，用于统计特定日期范围内不同用户和工作流程的任务量及实际工作量。通过联接多个表并使用子查询，该查询能够细致地分析每个用户的任务完成情况。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

select f.*, g.trueworkload  
  from (select a.username, d.batchcode, c.workflowname, count(*) workload  
          from t_systemuserinfo a,  
               t_genworkflow c,  
               t_batch d,  
               t_companyinfo e,  
               (select distinct batchid,  
                                companyid,  
                                userid,  
                                direction,  
                                fromwkfid,  
                                towkfid  
                  from dbo.T_WorkflowLog  
                 where dotime between '2008-09-02' and '2008-09-03') as b  
         where a.systemuserid = b.userid  
           and b.fromwkfid = c.genworkflowid  
           and b.batchid = d.batchid  
           and b.companyid = e.companyid  
         group by a.username, c.workflowname, d.batchcode) f,  
       (select a.username,  
               d.batchcode,  
               c.workflowname,  
               count(*) trueworkload  
          from t_systemuserinfo a,  
               t_genworkflow c,  
               t_batch d,  
               t_companyinfo e,  
               (select distinct batchid,  
                                companyid,  
                                userid,  
                                direction,  
                                fromwkfid,  
                                towkfid  
                  from dbo.T_WorkflowLog  
                 where dotime between '2008-09-02' and '2008-09-03') as b  
         where a.systemuserid = b.userid  
           and b.fromwkfid = c.genworkflowid  
           and b.batchid = d.batchid  
           and b.companyid = e.companyid  
           and e.datastatus = 1  
           and e.companyid not in  
               (select h.companyid  
                  from t_companyinfotmp h  
                 where h.batchid = b.batchid)  
         group by a.username, c.workflowname, d.batchcode, e.datastatus) g  
 where f.batchcode = g.batchcode  
   and f.workflowname = g.workflowname  
   and f.username = g.username  
union  
select f.*, g.trueworkload  
  from (select a.username, d.batchcode, c.workflowname, count(*) workload  
          from t_systemuserinfo a,  
               t_genworkflow c,  
               t_batch d,  
               t_companyinfotmp e,  
               (select distinct batchid,  
                                companyid,  
                                userid,  
                                direction,  
                                fromwkfid,  
                                towkfid  
                  from dbo.T_WorkflowLog  
                 where dotime between '2008-09-02' and '2008-09-03') as b  
         where a.systemuserid = b.userid  
           and b.fromwkfid = c.genworkflowid  
           and b.batchid = d.batchid  
           and b.companyid = e.companyid  
           and b.batchid = e.batchid  
         group by a.username, c.workflowname, d.batchcode) f,  
       (select a.username,  
               d.batchcode,  
               c.workflowname,  
               count(*) trueworkload  
          from t_systemuserinfo a,  
               t_genworkflow c,  
               t_batch d,  
               t_companyinfotmp e,  
               (select distinct batchid,  
                                companyid,  
                                userid,  
                                direction,  
                                fromwkfid,  
                                towkfid  
                  from dbo.T_WorkflowLog  
                 where dotime between '2008-09-02' and '2008-09-03') as b  
         where a.systemuserid = b.userid  
           and b.fromwkfid = c.genworkflowid  
           and b.batchid = d.batchid  
           and b.companyid = e.companyid  
           and e.datastatus = 1  
           and b.batchid = e.batchid  
         group by a.username, c.workflowname, d.batchcode, e.datastatus) g  
 where f.batchcode = g.batchcode  
   and f.workflowname = g.workflowname  
   and f.username = g.username compute sum(workload),  
 sum(trueworkload)

转载URL：http://blog.youkuaiyun.com/only_endure/article/details/4020708