mysql写法查询前15%的数据

MySQL 不能使用top，就得换个思路
SELECT g.* FROM (SELECT @rownum:=0) r join tb_shopping_car g where (@rownum:=@rownum+1)<=(select round(count(*)*0.15) from tb_shopping_car);
————————————————