asp 中 的sql 使用了count as 然后 group 分组还需要通过 count统计的数值进行排序，可是在ACCESS测试通过，在页面中就不行，请大哥帮我看看！

Question

sql="select hy,count(*) as ct from order where worker like '%"&worker&"%' group by hy order by ct desc"

如果去掉order by ct desc 就没错，但是如果用了就有错，如果order by hy 就没错，实在搞不懂为啥

Answer 1

sql="select * from (select hy,count(*) as ct from order where worker like '%"&worker&"%' group by hy) order by ct desc"