请问如果构造这条SQL语句？？

[danjingwu]

我有两个表，一张是会员信息表，一张是会员发表文章的表
会员信息表（userinfo）如下：
userid nickname logintime（最后登陆时间）
1 aa 2005-1-3
2 bb 2005-1-2
3 cc 2005-1-6
4 dd 2005-1-7

会员发表文章表（article）如下：
id userid title
1 1 AA
2 1 BB
3 2 CC
4 3 DD
5 3 EE
6 4 FF
7 3 GG
8 1 II

假如今天是2005-1-8
1。我想统计2天前有登陆本站的且发表的文章数少于2的会员资料
2。article表中，会员发表的文章数各是多少篇

请问各位如果构造这两条SQL语句，我对这个了解比较少，呵呵，谢谢！

[尚和空四]

错了

[sjjf]

如果数据库不支持 日期型数据直接比较的话，那么logintime > dateadd(dd,getdate(),-2)就会出错。
虽然这条sql没有调试，但是它应当是高效的。

[jincaogg]

其实，这些，你不知道很清楚的，可以在ACCESS 里建个这样的查询，然后在切换到SQL视图就可以看见了

[danjingwu]

我的数据库是SQL Server的，那要怎么建查询啊？

[klend]

1。
select userid,count(userid) as titlenum from article group by userid having count(userid) > 2

[若白师妹]

1。我想统计2天前有登陆本站的且发表的文章数少于2的会员资料
select count(userid),nickname from userinfo,article where userinfo.userid=article.userid and datediff(dd,userinfo.logintime,getdate)=2 group by userid,nickname having count(userid)<2

随便写的,可能有错误

[klend]

不好意思，错了
select userid,count(userid) as titlenum from article group by userid having count(userid) < 2

2。select userid,count(userid) as titlenum from article group by userid

titlenum字段就是每个userid对应的文章数

[dh20156]

1.TRY:
Select * from userinfo where datediff(d,logintime,'2005-1-8') > 2 and userid in (select userid from article group by userid having (count(userid)<2))

[若白师妹]

2。article表中，会员发表的文章数各是多少篇
select userid as 会员名称,count(userid) as 会员发表的文章数 from article group by userid

[crazydreamer]

1.sql="select * from userinfo where datediff(day,logintime,getdate())>2 and userid not in(select userid from article group by userid having count(1)>=2)"
2.sql="select userid,count(1) as publishnum from article group by userid"

[dh20156]

2.TRY:
select userid,count(userid) as tnum from article group by userid

[超级大笨狼]

时间段相关：
sql="select id,classid,classname,xiaoshoue,xiaoshou,jinhuo,kucun,addtime "
sql=sql&" from xiaoshou where addtime between '" & format(starttime,"yyyy-mm-dd") & "' and '" & format(endtime,"yyyy-mm-dd") & "'"
sql=sql&" order by id desc"

SELECT Fylb,Pm,Gg,Dw,Dj,Sl,Je FROM cqyzypzx where zxdate between {^2003-7-1} and {^2003-8-1}

近两个星期
sql="select * from table where datediff(week,riqi,getdate())<=2"

近三个月
sql="select * from table where datediff(month,riqi,getdate())<=3"

近一年
sql="select * from table where datediff(year,riqi,getdate())<=1"

[sjjf]

1.

select * from userinfo
where
logintime > dateadd(dd,getdate(),-2)
and
exists
(
select userid from article group by userid having count(*) < 2
)

[sjjf]

2.
select userid ,count(*) from article group by userid

[sjjf]

1.拷贝错了
select * from userinfo A
where
logintime > dateadd(dd,getdate(),-2)
and
exists
(
select userid from article B where a.userid=b.userid group by userid having count(*) < 2
)