mysql中limit限制输出的条目

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;