MySQL----order by 和limit

排序

MySQL中排序主要用的 ORDER BY，默认是升序,加DESC则为降序
按某一列排序

SELECT * FROM customers
ORDER BY first_name;

SELECT * FROM customers
ORDER BY first_name DESC;

按某几列排序

SELECT * FROM customers
ORDER BY first_name,last_name;

按算术表达式结果排序

SELECT * FROM customers
ORDER BY price*quantity;

limit

提取前三行

SELECT * FROM customers
ORDER BY price*quantity
limit 3;

跳过前面4行，提取3行

SELECT * FROM customers
ORDER BY price*quantity
limit 4,3;