mysql查询问题

Question

有两个表

新闻表 news 两个主要字段 newsId departmentId

新闻点击表 Hits 字段 newsid Hits time

新闻点击表是记录新闻表的点击量的 同一天的点击量会根据访问量增加  每天一条新闻对应一条数据，以time为标识

现在我想查询departmentid，根据新闻点击总量排序来查询news表的departmentid，要求departmentid根据点击量排序

这是我写的的查询语句，会报错

 

select departmentId from news where newsid in (select distinct newsid from hits group by newsid order by sum(hits) desc) order by field(newsid,(select group_concat(distinct newsid) from Hits group by newsid order by sum(hits) desc));

Answer 1

[code="sql"]select sum(h.hits) sumhits,n.departmentid from news n,hits h where n.newsid=h.newsid group by h.newsid order by sumhits[/code]