下面两个sql的目的是什么?作用一致吗?相比哪一条更好?
sql1:
<select id="selMarkContractSys" resultMap="sysMarkContract">
SELECT
c.*
FROM
hrbase_mark_contract c
INNER JOIN
(SELECT
work_id,
MAX(id) AS max_id
FROM
hrbase_mark_contract
WHERE
company_code != #{company_code}
AND work_id = #{work_id}
GROUP BY
work_id
) t ON c.work_id = t.work_id AND c.id >= t.max_id
WHERE
c.work_id = #{work_id}
AND c.company_code = #{company_code}
ORDER BY
c.id ASC
LIMIT 1
</select>
sql2:
<select id="selMarkContractSys" resultMap="sysMarkContract">
SELECT
*
FROM
(
SELECT
*
FROM
hrbase_mark_contract
WHERE
work_id = #{work_id}
ORDER BY
id DESC
) AS a
WHERE
company_code = #{company_code}
AND (
id = (
SELECT
MIN(id)
FROM
hrbase_mark_contract
WHERE
work_id = #{work_id}
AND id > (
SELECT
MAX(id)
FROM
hrbase_mark_contract
WHERE
company_code != #{company_code}
AND work_id = #{work_id}
)
)
OR (
SELECT
MAX(id)
FROM
hrbase_mark_contract
WHERE
company_code != #{company_code}
AND work_id = #{work_id}
) IS NULL
)
LIMIT 1
</select>
因篇幅问题不能全部显示,请点此查看更多更全内容
怀疑对方AI换脸可以让对方摁鼻子 真人摁下去鼻子会变形
女子野生动物园下车狼悄悄靠近 后车司机按喇叭提醒
睡前玩8分钟手机身体兴奋1小时 还可能让你“变丑”
惊蛰为啥吃梨?倒春寒来不来就看惊蛰
男子高速犯困开智能驾驶出事故 60万刚买的奔驰严重损毁