查询所有工资少于5000的员工姓名和工资:
mysql> select fname,fsalary from t_employee where fsalary<5000;
+-------+---------+
| fname | fsalary |
+-------+---------+
| Jerry | 2300.8 |
| Jane | 2200.88 |
| Smith | 3900 |
| Stone | 1200 |
+-------+---------+
4 rows in set
查询所有工资少于5000或年龄大于25岁的员工姓名、年龄和工资:
mysql> select fname,fage,fsalary from t_employee where fsalary<5000 or fage>25;
+-------+------+---------+
| fname | fage | fsalary |
+-------+------+---------+
| Jerry | 28 | 2300.8 |
| Jane | 23 | 2200.88 |
| Smith | 28 | 3900 |
| Kerry | 28 | 6200 |
| Stone | 22 | 1200 |
+-------+------+---------+
5 rows in set