select count(*) as total,id from a group by type order by total desc
如何做分页查询是
执行count是，生成的mysql语句:
select count(*) As tp_count from a group by type order by total desc
这sql语句报错,不应该加上order by
望解决一下~
最佳答案
select count(*) as total,id from a group by type order by total desc
如何做分页查询是
执行count是，生成的mysql语句:
select count(*) As tp_count from a group by type order by total desc
这sql语句报错,不应该加上order by
望解决一下~