MySQL必知必会(Select, Order by子句)
SELECT prod_name FROM products ORDER BY prod_name; SELECT prod_id, prod_price, prod_name FROM products ORDER BY prod_price, prod_name; SELECT prod_id, prod_price, prod_name FROM products ORDER BY prod_price DESC; #默认为ASC SELECT prod_id, prod_price, prod_name FROM products ORDER BY prod_price DESC, prod_name; SELECT prod_price FROM products ORDER BY prod_price DESC LIMIT 1;