摘要：Create table test (name char(10),km char(10),cj int)goinsert test values('张三','语文',80)insert test values('张三','数学',86)insert test values('张三','英语',75)insert test values('李四','语文',78)insert test values... 阅读全文

摘要：SELECT A.SiteSortID,B.Name,count(*) as Num FROM Article A,SiteSort B WHERE B.ID=A.SiteSortID and A.IsVisible = @IsVisible GROUP BY A.SiteSortID ,B.Name 以前还以为不可以.. 阅读全文