请教一个SQL汇总语句:把下表中按AA和BB汇总后的BB的个数(每个BB汇总1次),CC同理.use [MYTEST] CREATE TABLE [dbo].[Table_TEST]( [ID] [int] IDENTITY(1,1) NOT NULL,[AA] [nchar](10) NULL,[BB] [nchar](10) NULL,[CC] [nchar](10)
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/09 07:57:40
![请教一个SQL汇总语句:把下表中按AA和BB汇总后的BB的个数(每个BB汇总1次),CC同理.use [MYTEST] CREATE TABLE [dbo].[Table_TEST]( [ID] [int] IDENTITY(1,1) NOT NULL,[AA] [nchar](10) NULL,[BB] [nchar](10) NULL,[CC] [nchar](10)](/uploads/image/z/12429901-37-1.jpg?t=%E8%AF%B7%E6%95%99%E4%B8%80%E4%B8%AASQL%E6%B1%87%E6%80%BB%E8%AF%AD%E5%8F%A5%EF%BC%9A%E6%8A%8A%E4%B8%8B%E8%A1%A8%E4%B8%AD%E6%8C%89AA%E5%92%8CBB%E6%B1%87%E6%80%BB%E5%90%8E%E7%9A%84BB%E7%9A%84%E4%B8%AA%E6%95%B0%EF%BC%88%E6%AF%8F%E4%B8%AABB%E6%B1%87%E6%80%BB1%E6%AC%A1%EF%BC%89%2CCC%E5%90%8C%E7%90%86.use+%5BMYTEST%5D+CREATE+TABLE+%5Bdbo%5D.%5BTable_TEST%5D%28+%5BID%5D+%5Bint%5D+IDENTITY%281%2C1%29+NOT+NULL%2C%5BAA%5D+%5Bnchar%5D%2810%29+NULL%2C%5BBB%5D+%5Bnchar%5D%2810%29+NULL%2C%5BCC%5D+%5Bnchar%5D%2810%29)
请教一个SQL汇总语句:把下表中按AA和BB汇总后的BB的个数(每个BB汇总1次),CC同理.use [MYTEST] CREATE TABLE [dbo].[Table_TEST]( [ID] [int] IDENTITY(1,1) NOT NULL,[AA] [nchar](10) NULL,[BB] [nchar](10) NULL,[CC] [nchar](10)
请教一个SQL汇总语句:把下表中按AA和BB汇总后的BB的个数(每个BB汇总1次),CC同理.
use [MYTEST] CREATE TABLE [dbo].[Table_TEST]( [ID] [int] IDENTITY(1,1) NOT NULL,[AA] [nchar](10) NULL,[BB] [nchar](10) NULL,[CC] [nchar](10) NULL ) ON [PRIMARY] GO INSERT INTO [Table_TEST] (AA,BB,CC) VALUES ('a1','b2','c3'),('a1','b2','c1'),('a1','b1','c4'),('a2','b1','c1'),('a2','b2','c3') go 汇总后得到1行:AA、COUNT(BB)、COUNT(CC);2行:a1、2、3;3行:a2、2、2
请教一个SQL汇总语句:把下表中按AA和BB汇总后的BB的个数(每个BB汇总1次),CC同理.use [MYTEST] CREATE TABLE [dbo].[Table_TEST]( [ID] [int] IDENTITY(1,1) NOT NULL,[AA] [nchar](10) NULL,[BB] [nchar](10) NULL,[CC] [nchar](10)
select aa,count(distinct bb) as bb,count(distinct cc) as cc from tableName group by aa.