limit offset, N
offset 偏移量:相当于跳过几行 offset如果不写,相当于limit 0,N N 取出条目。
(1)Ecshop练习,取出最贵的前三个商品:
select goods_id,goods_name,shop_price from goods order by shop_price desc limit 3;
或者 select goods_id,goods_name,shop_price from goods order by shop_price desc limit 0,3;
(2)Ecshop练习,取价格高第三到第五名
select goods_id,goods_name,shop_price from goods order by shop_price desc limit 2,3;
mysql中limit限制输出的条目
最新推荐文章于 2022-07-27 10:35:45 发布