SQL Server 2019及以上版本嵌套查询与高级语句应用测试卷.docxVIP

SQLServer2019及以上版本嵌套查询与高级语句应用测试卷

创建测试数据库

CREATEDATABASESQLTestDB;

GO

USESQLTestDB;

GO

创建测试表

CREATETABLEEmployees(

EmployeeIDINTPRIMARYKEY,

FirstNameNVARCHAR(50),

LastNameNVARCHAR(50),

DepartmentIDINT,

SalaryDECIMAL(10,2)

);

CREATETABLEDepartments(

DepartmentIDINTPRIMARYKEY,

DepartmentNameNVARCHAR(50)

);

插入测试数据

INSERTINTODepartmentsVALUES(1,Sales),(2,Marketing),(3,IT),(4,HR);

INSERTINTOEmployeesVALUES(1,John,Doe,1,50000),(2,Jane,Smith,2,55000),(3,Jim,Brown,3,60000);

INSERTINTOEmployeesVALUES(4,Emily,Davi