select s.subjectId as 'Subject',count('s.subjectid') as 'Count'
from subject s inner join
Answer a on s.subjectId = a.subjectId
group by s.subjectId
这个语句的查询结果有四个,但是count却为3,
怎么回事啊。我想得到查询的个数怎么办啊,就是的到有几个s.subject
from subject s inner join
Answer a on s.subjectId = a.subjectId
group by s.subjectId
这个语句的查询结果有四个,但是count却为3,
怎么回事啊。我想得到查询的个数怎么办啊,就是的到有几个s.subject
from subject s inner join
Answer a on s.subjectId = a.subjectId
group by s.subjectId
select s.subjectId as 'Subject',count(s.subjectid) as 'Count'
from subject s inner join
Answer a on s.subjectId = a.subjectId
group by s.subjectId select s.subjectId as 'Subject',count(*) as 'Count'
from subject s inner join
Answer a on s.subjectId = a.subjectId
group by s.subjectId select s.subjectId as 'Subject',count(1) as 'Count'
from subject s inner join
Answer a on s.subjectId = a.subjectId
group by s.subjectId
from subject s inner join
Answer a on s.subjectId = a.subjectId
group by s.subjectId应该用 count(*) 统计所有的,你试试看!
from subject s inner join
Answer a on s.subjectId = a.subjectId
group by s.subjectId