SELECT prod_name
FROM Products;
通配符*
检索不同的值:
SELECT DISTINCT vend_id
FROM Products;
限制结果:
LIMIT 5 OFFSET 5;
排序数据:
SELECT prod_name
FROM Products
ORDER BY prod_name;
按列位置排序:
SELECT prod_name
FROM Products
ORDER BY 3, 4;
指定排序方向:
SELECT prod_name
FROM Products
ORDER BY prod_name DESC; -- 降序排序