select a.user_id ,a.user_name ,b.news_id ,b.news_title ,b.news_datefrom user a inner join news b on a.user_id = b.user_id where b.news_date like '2009-3-3% 'group by (a.user_id) 对 2009-3-3 这一天的所有信息,利用User表中的user_id进行排序where 后面的like 也可以改写成Between '2009-3-3' and '2009-3-4'查询3到4号之间的所有数据。多看看数据库操作指令http://hi.baidu.com/j...
select user_name,count from (select a.user_name user_name,count(*) count from user a,news b where a.user_id=b.user_idand news_date='年月日') cwhere order by count desc从多到少排...
select count(*),user_id from news a inner join user b on a.user_id=b.user_id where datediff(d,news_date,getdate())=0 group by user_id order by count(*) desc 试一下,应该可以通过的...
select [user_name],ct from [user] a,(select [user_id],news_date,count([user_id]) ct from newsgroup by [user_id],news_date) bwhere a.[user_id] = b.[user_id]order by news_dat...