关于新闻系统的热点新闻是怎么实现的啊？

如题
而且是比较近的，比如最近一个月的，sql怎么写啊
---------------------------------------------------------------

SELECT top 10 * FROM news where month(dateandtime)>=month(getdate()-1)order by hits desc
---------------------------------------------------------------

SELECT top 10 * FROM news where month(dateandtime)>=month(getdate()-1)order by hits desc