一个普通的SQL语句

iteye_21043

于 2009-09-17 22:00:51 发布

阅读量109

点赞数

文章标签： SQL C C++ C#

本文介绍了一个复杂的SQL查询案例，该查询用于统计用户的白班和夜班次数，并展示如何通过多个表之间的连接操作来获取特定时间范围内的用户工作记录。涉及子查询、连接查询以及聚合函数的使用。

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

select D.userName as 用户姓名, C.用户ID as 用户ID, C.白班次数 as 白班次数, C.夜班次数 as 夜班次数, C.统计年月 as 统计年月 from
表1 as D,
(select A.用户ID as 用户ID, A.白班次数 as 白班次数, B.夜班次数 as 夜班次数, B.年月 as 统计年月 from
(select userId as 用户ID, isNull(count(dutyId),0) as 白班次数, to_char(dutyDate,'yyyyMM') as 年月 from 表2 where dutyType='1' group by userId,to_char(dutyDate,'yyyyMM') asc to_char(dutyDate,'yyyyMM')) as A
full out join
(select userId as 用户ID, isNull(count(dutyId),0) as 夜班次数, to_char(dutyDate,'yyyyMM') as 年月 from 表2 where dutyType='2' group by userId,to_char(dutyDate,'yyyyMM') asc to_char(dutyDate,'yyyyMM')) as B
on A.用户ID=B.用户ID, A.年月 = B.年月) as C)
where C.用户ID=D.userId