sql 两张表关联提前最新的数据

[ct415884941]

SELECT
a.车牌号码,
b.操作时间
FROM
总表 AS a
LEFT JOIN 操作记录 AS b ON a.车牌号码 = b.[车牌号码]
WHERE
a.车牌号码 = 'H18976'

我想只取最后一次数据 应该如何写 不懂 麻烦告知一下谢谢

[二月十六]

SELECT TOP 1
    a.车牌号码,
    b.操作时间
FROM 总表 AS a
    LEFT JOIN 操作记录 AS b
        ON a.车牌号码 = b.[车牌号码]
WHERE a.车牌号码 = 'H18976'
ORDER BY b.操作时间 DESC;