挑战SQL查询语句(在线) select UserID,UserName,Sex, count(*) as countfrom A,Bwhere A.UserID = B.UserIDgroup by UserID,UserName,Sex 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select A.UserID,UserName,Sex, count(*) as countfrom A,Bwhere A.UserID = B.UserIDgroup by UserID,UserName,Sex Select a.UserID,a.UserName,a.Sex,tmp.CountS from(Select UserID,CountS=Count(UserID) From 表B Group by UserID)tmp, 表A a where a.UserID=tmp.UserID try:select A.UserID,A.UserName,A.Sex,Count(B.UserID) from a,b where a.userid=b.useridgroup by b.userid Select a.UserID,a.UserName,a.Sex,b.Count_ from 表A a,(select UseeId,count(UserId) as count_ from 表B group by UserID) b where a.UserID=b.UserID select a.UserID,a.UserName,a.Sex, count(*) as countfrom A Join B On A.UserID = B.UserIDgroup by a.UserID,a.UserName,a.Sex Select a.UserID,a.UserName,a.Sex,b.Countsfrom 表A a,(select UseeId,count(UserId) as counts from 表B group by UserID) b where a.UserID=b.UserID 获取存储过程返回值 drop table test..stucopy? 多個沒關聯的表如何組合查詢? 一个简单的数据转置。 关于数据库的安装问题!请大家帮我解决一下! SQL在查询分析器中执行不成功,在VB开发的程序中没有任何提示,想获取提示怎么做? 该包中包含两个具有重复名称 c#调用mssql视图生成xls文件的问题? 关于SQLSERVER扩展存储过程的问题 一条SQL2000字符串匹配的问题! 有没有人帮我详细的说一下几种join关系 有本事的就进来。。。。。
from A,B
where A.UserID = B.UserID
group by UserID,UserName,Sex
from(Select UserID,CountS=Count(UserID) From 表B Group by UserID)tmp, 表A a
where a.UserID=tmp.UserID
select A.UserID,A.UserName,A.Sex,Count(B.UserID) from a,b where a.userid=b.userid
group by b.userid
from A Join B On A.UserID = B.UserID
group by a.UserID,a.UserName,a.Sex
from 表A a,
(select UseeId,count(UserId) as counts from 表B group by UserID) b
where a.UserID=b.UserID