在写sql 语句的时候,一定要将group by 放在order by 之前 如select * from table where name='xx' group by sid order by id;