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 就没错,实在搞不懂为啥
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 就没错,实在搞不懂为啥
sql="select * from (select hy,count(*) as ct from order where worker like '%"&worker&"%' group by hy) order by ct desc"