SQL学习说明五来度量和分配新字段的值

删除重复数据
添加两个字段
修改表t_employee添加fsubcompany varchar（20）；
修改表t_employee添加fdepartment varchar（20）；

为新添加的字段分配一个值
UPDATE T_Employee SET FSubCompany='Beijing', FDepartment='Development' where FNumber='DEV001';
更新t_employee集fsubcompany =深圳市，fdepartment == 'dev002数量的快速增加；
更新t_employee集fsubcompany =北京，fdepartment = 'humanresource哪里fnumber = 'hr001；
更新t_employee集fsubcompany =北京，fdepartment = 'humanresource哪里fnumber = 'hr002；
更新t_employee集fsubcompany =北京，fdepartment = 'infotech哪里fnumber = 'it001；
更新t_employee集fsubcompany =深圳市，fdepartment = 'infotech哪里fnumber = 'it002；
更新t_employee集fsubcompany =北京，fdepartment = 'sales哪里fnumber = 'sales001；
更新t_employee集fsubcompany =北京，fdepartment = 'sales哪里fnumber = 'sales002；
更新t_employee集fsubcompany =深圳市，fdepartment = 'sales哪里fnumber = 'sales003；

查询并返回权重
选择不同的fdepartment从t_employee

选择不同的fdepartment，FSubCompany从t_employee