SQL 查询员工最新合同：根据工号和公司代码筛选

SELECT Id, WorkId, Name, ContractNo, ContractType, ContractTime, IsSyq, SyqSDate, SyqEDatte, ContractSDate, ContractEDate, DataStatus, IsDeleted, CUser, CDate, LUser, LDate, SyqMonth, ZZDate, CompanyCode, ContDesc, COptType, SignCompanyCode, TermMode, ContractTimeMonth, Remark, Mark FROM Sys_MarkContract WHERE WorkId = '${work_id}' ORDER BY ID ASC

WITH RankedContracts AS ( SELECT Id, WorkId, CompanyCode, ROW_NUMBER() OVER (PARTITION BY WorkId ORDER BY ID DESC) AS RowNum FROM Sys_MarkContract WHERE WorkId = '${work_id}' ) SELECT rc.Id, rc.WorkId, rc.CompanyCode FROM RankedContracts rc WHERE rc.RowNum = 1 AND rc.CompanyCode = '${company_code}'