SELECT DATEPART(YEAR, t_kqlist23.RQCHAR) AS [Year], DATEPART(MONTH, t_kqlist23.RQCHAR) AS [Month], t_kqlist23.BSIN AS BSIN, t_kqlist23.ESOUT AS ESOUT, T_JKDX.YDJBH AS card_number, T_BM_BM.BMMC AS department, T_BM_ZW.ZWMC AS duties, T_JKDX.XM AS name, T_BM_GZ.GZMC AS work_type_name, COUNT(*) AS [Count] FROM [cxrydw].[guoxw].[t_kqlist23] AS t_kqlist23 LEFT JOIN [cxrydw].[guoxw].[T_JKDX] AS T_JKDX ON T_JKDX.XTBH = t_kqlist23.XTBH LEFT JOIN [cxrydw].[guoxw].[T_BM_BM] AS T_BM_BM ON T_BM_BM.BMBM = T_JKDX.BMBM LEFT JOIN [cxrydw].[guoxw].[T_BM_ZW] AS T_BM_ZW ON T_BM_ZW.ZWBM = T_JKDX.ZWBM LEFT JOIN [cxrydw].[guoxw].[T_BM_GZ] AS T_BM_GZ ON T_BM_GZ.GZBM = T_JKDX.GZBM WHERE DATEPART(YEAR, t_kqlist23.RQCHAR) = 2023 AND t_kqlist23.XTBH = '17' GROUP BY DATEPART(YEAR, t_kqlist23.RQCHAR), DATEPART(MONTH, t_kqlist23.RQCHAR), t_kqlist23.BSIN, t_kqlist23.ESOUT, T_JKDX.YDJBH, T_BM_BM.BMMC, T_BM_ZW.ZWMC, T_JKDX.XM, T_BM_GZ.GZMC ORDER BY [Year], [Month] 查询出每月的数据条数
时间: 2024-04-13 11:25:00 浏览: 191
SQL_SERVER_2005常用系统函数【学习总结】
这个SQL查询语句是用于查询指定年份和XTBH的每个月的数据条数。它从多个表中选择了一些列,并进行了一系列的JOIN操作。然后,使用DATEPART函数提取出年份和月份,并对这些列进行分组。最后,使用COUNT函数计算每个组的数据条数,并按年份和月份进行排序。
注意:这个查询语句是基于SQL Server的语法,如果你使用的是其他数据库,可能需要进行适当的调整。
阅读全文