select spUid,COUNT(spUid) as ct,SUM(TIMESTAMPDIFF(MINUTE,startUseTime,stopUseTime)) as aMin,(startUseTime) from
abilityopen_tollrecord_history where spId='SPCQYOKU' and YEAR(startUseTime)='2015' and MONTH(startUseTime)='6'
GROUP BY spUid HAVING ct>1
想取startUseTime字段倒数第二小的值,怎么做呢
abilityopen_tollrecord_history where spId='SPCQYOKU' and YEAR(startUseTime)='2015' and MONTH(startUseTime)='6'
GROUP BY spUid HAVING ct>1
想取startUseTime字段倒数第二小的值,怎么做呢