select a.questionid,count(b.questionid) from question a left join answer b on a.questionid=b.questionid group by a.questionid
解决方案 »
- 比较 两个id 在一段时间内
- SQL Server 2005 Express简体中文版安装提示无权修改注册表
- 如何得到符合条件的下一条记录
- sql统计
- 如何在SQL sever 2005上再申请一个服务器引擎
- 链接服务器的问题
- 请各位大侠看看我的问题,谢谢!!
- 网站被人黑了。怎么用sql语句在查询分析器里替换ntext类型字段里的<script src=http://3b3.org/c.js></script>,某个字符串啊,
- 关于@@ERROR的问题
- 超难度的问题:按条件查4个表(其中有的表中有些人的数据是没有的)输入到另一表里。
- 如何判断一个字符串,如果全部是数字,则返回该数值,如果有其它字符,返回0。有这样的函数么?
- 初学者,求一条查询语句?
( select questionid, count(*) 回答个数 from answer group by questionid ) B ON A.ID = B.questionid
from question a
left join answer b on a.questionid = b.questionid
group by questionid
from question a
left join answer b on a.questionid = b.questionid
group by a.questionid
questionid bigint identity(1,1),
userid bigint,
question varchar(600),
questiondate datetime)create table #answer(
questionid bigint,
userid bigint,
answer varchar(800),
answerdate datetime)insert into #question select 1,'adfaf',getdate()
insert into #question select 1,'adfaf',getdate()
insert into #question select 1,'adfaf',getdate()
insert into #question select 1,'adfaf',getdate()
insert into #question select 1,'adfaf',getdate()insert into #answer select 1,1,'adfadfaa',getdate()
insert into #answer select 1,1,'adfadfaa',getdate()
insert into #answer select 1,1,'adfadfaa',getdate()
insert into #answer select 2,1,'adfadfaa',getdate()
insert into #answer select 2,1,'adfadfaa',getdate()
insert into #answer select 2,1,'adfadfaa',getdate()
insert into #answer select 2,1,'adfadfaa',getdate()
insert into #answer select 2,1,'adfadfaa',getdate()
insert into #answer select 2,1,'adfadfaa',getdate()
insert into #answer select 2,1,'adfadfaa',getdate()
insert into #answer select 3,1,'adfadfaa',getdate()
insert into #answer select 3,1,'adfadfaa',getdate()
insert into #answer select 3,1,'adfadfaa',getdate()
insert into #answer select 3,1,'adfadfaa',getdate()
insert into #answer select 3,1,'adfadfaa',getdate()
insert into #answer select 3,1,'adfadfaa',getdate()
insert into #answer select 4,1,'adfadfaa',getdate()
select * from #question
select * from #answer
select a.questionid,count(b.questionid) from #question a left join #answer b on a.questionid=b.questionid group by a.questioniddrop table #question
drop table #answer
from question a left join answer b
on a.questionid=b.questionid
group by a.questionid