2020-07-25

基础查询的练习

显示表departments的结构，并查询其中的全部数据 desc 表名;

select * from departments;desc departments;

显示出表employees中的全部job_id（不能重复）distinct

select DISTINCT job_id from employees ;

显示出表employees的全部列，各个列之间用逗号连接，列头显示成OUT_PUT

select CONCAT(first_name,’,’,salary,’,’,email) out_put from employees

显示出表employees部门编号在80-100之间 的姓名、职位

select first_name,email from employees where department_id between 80 and 100;select first_name,email from employees where department_id >= 80 and department_id <= 100;

显示出表employees的manager_id 100,101,110 的员工姓名、职位

select first_name, job_id from employees where manager_id = 100 or manager_id =101 or manager_id = 110;