top order by 语句数值重复问题(语句有些复杂)
sqltopdep="select top 5 original, COUNT(original) as totail from EC_News where updatetime >= #"& date1 &"# and updatetime <= #"& date2 &"# group by original having COUNT(original) >= 1 order by COUNT(original) desc
用上述语句 得到的数据条数不超过5条
请问下该怎么解决,可以加个updatetime(文章上传时间)这个条件排序,该怎么更改语句呢?