员工信息表[员工号,姓名,性别],T_Worker[WorkerId,name,sex]
员工迟到表[员工号,迟到日期,迟到时长],T_Late[WorkerId,latetime,latelong]
1.在 日期1 (2008-4-2) 到日期2 (2008-4-4) 之间迟到的员工姓名
2.查询员工姓名含有O的员工信息
3.更改员工号为00001的员工的姓名为Jack
4.迟到两次以上的员工号
5.没有迟到的员工信息(用Join)
6.编写触发器,当删除员工信息时,同时删除对应的迟到记录
--select T_Worker.name from T_Worker where T_Worker.WorkerId in(select T_Late.WorkerId from T_Late where T_Late.latetime between '2008-4-2' and '2008-4-4')
--select * from T_Worker where name like '%林%';
--update T_Worker set name = 'Jack' where WorkerId = '0001';
--select WorkerId from T_Late group by WorkerId having count(*)>=2;
--select T_Late.WorkerId,T_Worker.name,T_Worker.sex,T_Late.latetime,T_Late.latelong from T_Worker inner join T_Late on T_Worker.WorkerId = T_Late.WorkerId and T_Late.latetime is NULL order by T_Worker.WorkerId;