SELECT
*
FROM
( SELECT ROW_NUMBER() OVER ( PARTITION BY b.AlarmID ORDER BY b.ResponseTime desc ) AS `ROW`,b.* FROM a_alarm_response b ) a
WHERE
a.ROW = 1
SELECT
*
FROM
( SELECT ROW_NUMBER() OVER ( PARTITION BY b.AlarmID ORDER BY b.ResponseTime desc ) AS `ROW`,b.* FROM a_alarm_response b ) a
WHERE
a.ROW = 1