实训5:
Desc Employees;
问题:ERROR 1146 : Table 'test.empartment' doesn't exist
PC运行无问题,猜测上课机房软件问题的原因
- SELECT语句的基本使用
- 查询Employees表的员工部门号和性别,要求消除重复行
SELECT `员工部门号`,`性别`
FROM employees;
要求消除重复行
SELECT DISTINCT `员工部门号`,`性别`
FROM employees;
书本例子:显示表中所有列
SELECT*FROM Employees;
AS子句可更改查询结果的列名:
SELECT 书名 AS name,作者 AS auther,出版社 AS publisher
FROM Book
WHERE 图书类别=’计算机’;
- 计算每个雇员的实际收入(实际收入=收入-支出)
SELECT 员工编号,收入-支出 AS 实际收入
FROM salary;
③查询Employees表中员工的姓名和性别,要求性别值为1时显示为"男",为0时显示为”女”
SELECT 姓名,
CASE
WHEN 性别 = 0 THEN ‘女’
ELSE ‘男’