SQL基础（八）--SELECT

查询所有工资少于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