mysql - 按行的时差

Question

我想获取多行之间的时间差

  Sl_id   ID     ShortLeave               createddate

    15    8     2015-10-02 13:10:07   2015-02-11 16:08:01
    16    8     2015-10-02 14:05:07   2015-02-11 16:08:01

我需要通过 where Id=1 获取短假差异过滤器。我试过了

SELECT  timediff(A.shortleave,B.shortleave) AS timedifference
FROM shortL A  JOIN shortL B ON B.id = A.id 
where A.Id=1
group by A.ID,A.ShortLeave ;

但我有两行

'00:00:00'
'00:55:00'

发生这种情况是因为Sl_id。所以请帮助我如何为多行只获取一行。

Answer 1

我改变了我的查询

SELECT  timediff(A.shortleave,B.shortleave) AS timedifference
FROM shortL A  JOIN shortL B ON B.id = A.id 
where A.Id=1
group by A.ID,A.ShortLeave order by timedifference desc limit 1;

通过这样做，我总是能得到最新的专栏。在此我只得到 '00:55:00' 结果，没关系。