挑战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 安装问题 存储过程的功能有哪些 为什么拼凑的sql语句可以被注入?? 有没有修改系统时间的函数? 谁能解释下下面6个数据库名词之间的关系和联系: 如何取分组的TOPN记录 sp_executesql 請教 numeric错误 在开发财务软件时如何建库? sql语句修改表自增列种子值 有没有人帮我详细的说一下几种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