mysql实验四_实验四 数据库查询

1、  查询Departments表中的所有记录；

Use  yggl;

Select  *  from  departments;

2、  查询Employees表中员工的姓名，地址和电话；

Select name,address,phonenumber

From employees;

3、  查询Employees表中员工的部门号和性别，要求消除重复行；

Select distinct departmentid,sex

From employees;

4、  查询EmployeeID为000001的员工地址和电话，要求显示列名为address、telephone；

Select address as address,phonenumber as telephone

From employees

Where employeeid = ‘000001’;

<