求一条查询语句.

[神码浮云]

一个项目表,一个留言表.(留言表有一个项目的id字段)

我想做一个根据留言条数最多的项目从上到下的排序.

请问这个是怎么实现呢,直接能从留言表查出来吗?

[yan11cn]

select * from (select id, count(留言) as c from 留言表 group by id)b order by b.c desc

[shenzhenNBA]

这个小题目有点费神哦, 借助中间表

select [id], count(id) as num into [#tempTB] from 留言表  group by [ID] order by num desc

select a.* from [项目表] a, [#tempTB] b where a.[id]=b.[id] order by b.num desc

drop table tempTB

[shenzhenNBA]

drop table [#tempTB]