SELECT
finalTable.macDir
, finalTable.macTime
, finalTable.macStatus
FROM
( SELECT
macDir
, MAX( macTime ) AS maxTime
FROM
macTable
GROUP BY
macDir
) AS lastestValues
INNER JOIN macTable AS finalTable
ON lastestValues.macDir = finalTable.macDir
AND lastestValues.maxTime = finalTable.macTime