27,579
社区成员
发帖
与我相关
我的任务
分享
2005以上版本還是2000?
--2000
select
a.[user].a.[class],count(b.[user]) con,班级記錄=(select count(*) from 留言表 where [user]=a.user and [time] between @StartDate and @EndDate)
from
人员信息表 a
left join
留言表 b on a.[user]=b.[user] and b.[time] between @StartDate and @EndDate--條件一段时间内
group by a.[user].a.[class]
select
a.[class],a.[user],count(b.[user]) con
from
人员信息表 a
left join
留言表 b on a.[user]=b.[user] and b.[time] between 起始时间 and 结束时间
group by a.[class], a.[user]
select
a.[user].a.[class],count(b.[user]) con
from
人员信息表 a
left join
留言表 b on a.[user]=b.[user] and b.[time] between @StartDate and @EndDate--條件一段时间内
group by a.[user].a.[class]
select
a.[user].a.[class],count(b.[user]) con
from
人员信息表 a
left join
留言表 b on a.[user]=b.[user]
group by a.[user].a.[class]
select b.class,a.content
from 留言表 a
left join 人员信息表 b
on a.user = b.user
order by b.class