3.排序检索数据

#排序检索
SELECT prod_name FROM products RDER 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 2,3;
#混合使用
SELECT prod_id,prod_price,prod_name FROM products ORDER BY 2,vend_id;
#降序
SELECT prod_id,prod_price,prod_name FROM products ORDER BY prod_price DESC;
#多个列降序
SELECT prod_id,prod_price,prod_name FROM products ORDER BY prod_price DESC,prod_name DESC;