https://blog.youkuaiyun.com/a28528zh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/a28528/article/details/158097577https://blog.youkuaiyun.com/a28528/article/details/158097577a28528Sun, 15 Feb 2026 09:26:56 +0800https://blog.youkuaiyun.com/a28528/article/details/158097184https://blog.youkuaiyun.com/a28528/article/details/158097184a28528Sun, 15 Feb 2026 07:38:43 +0800https://blog.youkuaiyun.com/a28528/article/details/158096920https://blog.youkuaiyun.com/a28528/article/details/158096920a28528Sun, 15 Feb 2026 05:53:07 +08001 的 ct 字段值，值大于1 的表示该题目出现的个数。另外命令结果增加了4个行，包括单选题统计共 248 题，多选题统计共 113 题，判断题统计共 293 题，总数统计共 654 题。主要是通过 case when 语句对 title 字段进行判断 ，为NULL值的表示汇总行，则进行 isnull(etype,‘总数’)+‘统计情况：’ 的字符串拼接，etype字段为 NULL 值的表示总数的统计行。]]>https://blog.youkuaiyun.com/a28528/article/details/158096550https://blog.youkuaiyun.com/a28528/article/details/158096550a28528Sun, 15 Feb 2026 04:07:55 +0800https://blog.youkuaiyun.com/a28528/article/details/158096064https://blog.youkuaiyun.com/a28528/article/details/158096064a28528Sun, 15 Feb 2026 02:22:23 +0800https://blog.youkuaiyun.com/a28528/article/details/158067554https://blog.youkuaiyun.com/a28528/article/details/158067554a28528Sat, 14 Feb 2026 09:57:58 +0800https://blog.youkuaiyun.com/a28528/article/details/158044358https://blog.youkuaiyun.com/a28528/article/details/158044358a28528Fri, 13 Feb 2026 21:44:04 +0800https://blog.youkuaiyun.com/a28528/article/details/157987630https://blog.youkuaiyun.com/a28528/article/details/157987630a28528Thu, 12 Feb 2026 02:29:46 +0800https://blog.youkuaiyun.com/a28528/article/details/157986105https://blog.youkuaiyun.com/a28528/article/details/157986105a28528Thu, 12 Feb 2026 01:44:03 +0800https://blog.youkuaiyun.com/a28528/article/details/157968572https://blog.youkuaiyun.com/a28528/article/details/157968572a28528Wed, 11 Feb 2026 04:03:54 +0800https://blog.youkuaiyun.com/a28528/article/details/157967946https://blog.youkuaiyun.com/a28528/article/details/157967946a28528Wed, 11 Feb 2026 01:43:54 +0800https://blog.youkuaiyun.com/a28528/article/details/157928394https://blog.youkuaiyun.com/a28528/article/details/157928394a28528Tue, 10 Feb 2026 04:09:06 +0800https://blog.youkuaiyun.com/a28528/article/details/157924394https://blog.youkuaiyun.com/a28528/article/details/157924394a28528Tue, 10 Feb 2026 01:49:16 +0800https://blog.youkuaiyun.com/a28528/article/details/157912744https://blog.youkuaiyun.com/a28528/article/details/157912744a28528Mon, 09 Feb 2026 23:25:20 +0800https://blog.youkuaiyun.com/a28528/article/details/157912225https://blog.youkuaiyun.com/a28528/article/details/157912225a28528Mon, 09 Feb 2026 22:38:17 +0800https://blog.youkuaiyun.com/a28528/article/details/157868739https://blog.youkuaiyun.com/a28528/article/details/157868739a28528Sun, 08 Feb 2026 06:11:05 +0800https://blog.youkuaiyun.com/a28528/article/details/157868360https://blog.youkuaiyun.com/a28528/article/details/157868360a28528Sun, 08 Feb 2026 03:51:55 +0800https://blog.youkuaiyun.com/a28528/article/details/157834088https://blog.youkuaiyun.com/a28528/article/details/157834088a28528Sat, 07 Feb 2026 06:32:04 +0800https://blog.youkuaiyun.com/a28528/article/details/157828881https://blog.youkuaiyun.com/a28528/article/details/157828881a28528Sat, 07 Feb 2026 04:02:21 +0800https://blog.youkuaiyun.com/a28528/article/details/157798343https://blog.youkuaiyun.com/a28528/article/details/157798343a28528Fri, 06 Feb 2026 03:04:43 +0800