巧妙的取到最新时间
SELECT tvsi1.cont_beg_date,
tvsi1.cont_end_date,
tvsi1.company_code,
tvsi1.service_manager service_manager_id,
su.real_name service_manager,
tvsi2.cont_end_date
FROM
t_vend_sign_info tvsi1
LEFT JOIN t_vend_sign_info tvsi2 ON tvsi1.company_code = tvsi2.company_code
AND tvsi1.cont_end_date < tvsi2.cont_end_date
LEFT JOIN sa_user su ON su.id = tvsi1.service_manager
WHERE tvsi2.cont_end_date IS NULL and tvsi1.company_code= '000049'
数据表结构三条数据为同一个公司三年签的不同合同
不包含表2 字段为空时的查询结果
包含表2 字段为空的查询结果
个中神奇之处自行体会