我要评论作业
mysql> create table tea(
-> id int unsigned auto_increment primary key,
-> name varchar(50),
-> age int,
-> salary int,
-> desclib varchar(50) default null
-> )charset=utf8;
insert into tea(name,age,salary) values ('jackie','19','9000');
insert into tea(name,age,salary) values ('coach','32','30000');
insert into tea(name,age,salary) values ('andy','26','15000');
insert into tea(name,age,salary) values ('jinx','16','3500');
# 1. 查看岗位是teacher的员工姓名、年龄
select name,age from tea;
# 2. 查看岗位是teacher且年龄大于30岁的员工姓名、年龄
select name,age from tea where age>30;
# 3. 查看岗位是teacher且薪资在9000-1000范围内的员工姓名、年龄、薪资
select name,age,salary from tea where salary between 1000 and 9000;
# 4. 查看岗位描述不为null的员工信息
select * from tea where desclib is not null;
# 5. 查看岗位是teacher且薪资是10000或9000或30000的员工姓名、年龄、薪资
select name,age,salary from tea where salary in (10000,9000,30000)
# 6. 查看岗位是teacher且薪资不是10000或9000或30000的员工姓名、年龄、薪资
select name,age,salary from tea where salary not in (10000,9000,30000);
# 7. 查看岗位是teacher且名字是jin开头的员工姓名、年薪
select name,salary*12 from tea where name like 'jin%';
您可能感兴趣的文章:
如您对本文有疑问或者有任何想说的，请点击进行留言回复，万千网友为您解惑！
网友评论