一、实验目的
1.掌握SELECT语句的基本用法;
2.掌握子查询表示;
3.掌握直接查询表示;
4.掌握SELECT语句中的GROUP BY子句的作用和使用方法;
5.掌握SELECT语句中的ORDER BY子句的作用和使用方法;
6.掌握SELECT语句中的LIMIT子句的作用和使用方法;
二、实验内容与实验结果
1.SELECT语句的基本使用
(1)use YGGL;
select * from Employees;
(2)select Name,Address,PhoneNumber
from Employees;
a.用SELECT语句查询Departments 和Salary表的一行或者若干列;
select DepartmentID,DepartmentName
from Departments;
select EmployeesID,InCome,OutCome
from Salary
where EmployeesID=’010008’ ;
(3) select Address,PhoneNumber
from Employees
where EmployeesID= ‘000001’;
(4) select Address as 地址,PhoneNumber as 电话
from Employees
where sex =’0’;
(5)select Name as 姓名,
case
when Sex=’1’ then ‘男’
when Sex=’0’ then ‘女’
end as 性别
from Employees;
(6)select EmployeesID,InCome-OutCome as 实际收入
from Salary;
(7)select COUNT(*)
from Employees;
(8)select DepartmentID
from Employees
where name like ‘王%’;