table: products
- 检索单个/多个列
SELECT name, price FROM products
- 检索所有列
SELECT * FROM products
- 去除名称相同的数据,只显示不同的数据
SELECT DISTINCT name FROM products
- 限制结果:只显示前5行
SELECT name FROM products LIMIT 5
- 只显示第6行开始,往下的3行
SELECT name FROM products LIMIT 6,3
排序:
- 从高到低,s只按照name从高到低排序,price不排序,但是默认从低到高。
SELECT name, price FROM products ORDER BY name DESC
- 显示价格最贵的那个产品
SELECT name price FROM products ORDER BY price DESC LIMIT 1