我有一个奇怪的问题,当我第一次运行 sql 命令时,它显示错误的结果,但是当我第二次运行相同的代码时,结果是正确的。错误的结果是:
预期的结果是:
sql命令是:
SELECT srNumber, end_on, start_on, teamEntityId
FROM (
SELECT srNumber, end_on, start_on, teamEntityId,
@lastrow := IF(@sr_Number = srNumber, @lastrow + 1,
IF(@sr_Number := srNumber, 1, 0)) AS lastrow
FROM assign
CROSS JOIN (SELECT @lastrow := 0, @sr_Number = '') AS vars
ORDER By srNumber, assignId DESC) AS t
WHERE t.lastrow = 1 AND t.teamEntityId = '00000168752ac161-02420aff00230001'
我要感谢Alex和Salman A解决了以下问题:
替换下面的代码
@sr_Number = ''
至
@sr_Number := ''
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句