1.查看岗位是teacher的员工姓名、年龄
mysql> select * from emp;
+----+---------+--------+------+--------+--------+-----------+
| id | name | gender | age | salary | area | port |
+----+---------+--------+------+--------+--------+-----------+
| 1 | yangsir | 男 | 42 | 10.5 | 上海 | 浦东 |
| 2 | engo | 男 | 38 | 9.4 | 山东 | 济南 |
| 3 | jerry | 女 | 30 | 3 | 江苏 | 张家港 |
| 4 | tank | 女 | 28 | 2.4 | 广州 | 广东 |
+----+---------+--------+------+--------+--------+-----------+
4 rows in set (0.00 sec)
mysql> select name,age from emp;
+---------+------+
| name | age |
+---------+------+
| yangsir | 42 |
| engo | 38 |
| jerry | 30 |
| tank | 28 |
+---------+------+
4 rows in set (0.00 sec)
2.查看岗位是teacher且年龄大于30岁的员工姓名、年龄
mysql> select name,age from emp where age>30;
+---------+------+
| name | age |
+---------+------+
| yangsir | 42 |
| engo | 38 |
+---------+------+
2 rows in set (0.00 sec)
3.查看岗位是teacher且薪资在0.9w-3w范围内的员工姓名、年龄、薪资
mysql> select name,age,salary from emp where salary between 0.9 and 3;
+-------+------+--------+
| name | age | salary |
+-------+------+--------+
| jerry | 30 | 3 |
| tank | 28 | 2.4 |
+-------+------+--------+
2 rows in set (0.00 sec)
4.查看岗位是teacher且薪资是2.4或3.0或9.4的员工姓名、年龄、薪资
mysql> select name,age,salary from emp where salary=2.4 or salary=3.0 or salary=9.4;4;
+-------+------+--------+
| name | age | salary |
+-------+------+--------+
| engo | 38 | 9.4 |
| jerry | 30 | 3.0 |
| tank | 28 | 2.4 |
+-------+------+--------+
3 rows in set (0.00 sec)
5.查看岗位是teacher且薪资不是2.4或3.0或9.4的员工姓名、年龄、薪资
mysql> select name,age,salary from emp where salary not in (9.4,3.0,2.4);
+---------+------+--------+
| name | age | salary |
+---------+------+--------+
| yangsir | 42 | 10.5 |
+---------+------+--------+
1 row in set (0.02 sec)
6.查看岗位是teacher且名字是j开头的员工姓名、年薪
mysql> select name,age,salary from emp where name like 'j%';
+-------+------+--------+
| name | age | salary |
+-------+------+--------+
| jerry | 30 | 3.0 |
+-------+------+--------+
1 row in set (0.00 sec)