mysql实验四"/>
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’;
<
更多推荐
mysql实验四
发布评论