selectsql7.sql

该章文件夹Chap2下存放的都是SQL脚本文件

USE PERSONNEL_SYS
SELECT WORKER_NAME AS 员工名称, SEX AS 性别 , DEPARTMENT_NAME  AS 部门名称
FROM  BASE_DATA
WHERE WORKER_NAME LIKE '%王%'
GO