提供了编程的基础技术教程

zl程序教程

您现在的位置是：首页 >  后端

当前栏目

SQL学习笔记五去重，给新加字段赋值的方法

方法SQL笔记学习 赋值 加字段
2023-06-13 09:14:30 时间
去掉数据重复
增加两个字段
alterTABLET_EmployeeAddFSubCompanyVARchar(20);
ALTERTABLET_EmployeeADDFDepartmentVARCHAR(20);

给新加的字段赋值
UPDATET_EmployeeSETFSubCompany="Beijing",FDepartment="Development"whereFNumber="DEV001";
UPDATET_EmployeeSETFSubCompany="ShenZhen",FDepartment="Development"whereFNumber="DEV002";
UPDATET_EmployeeSETFSubCompany="Beijing",FDepartment="HumanResource"whereFNumber="HR001";
UPDATET_EmployeeSETFSubCompany="Beijing",FDepartment="HumanResource"whereFNumber="HR002";
UPDATET_EmployeeSETFSubCompany="Beijing",FDepartment="InfoTech"whereFNumber="IT001";
UPDATET_EmployeeSETFSubCompany="ShenZhen",FDepartment="InfoTech"whereFNumber="IT002";
UPDATET_EmployeeSETFSubCompany="Beijing",FDepartment="Sales"whereFNumber="SALES001";
UPDATET_EmployeeSETFSubCompany="Beijing",FDepartment="Sales"whereFNumber="SALES002";
UPDATET_EmployeeSETFSubCompany="ShenZhen",FDepartment="Sales"whereFNumber="SALES003";

查询并去重
selectdistinctFDepartmentfromT_Employee

selectdistinctFDepartment,FSubCompanyfromT_Employee

相关文章