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);
————————————————
mysql写法查询前15%的数据
最新推荐文章于 2022-02-15 17:41: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);
————————————————