该rank窗口子句允许你，好了，根据一些分区排名行，然后你可以只选择顶部的：
SELECT oDate, oName, oItem, oQty, oRemarks
FROM (SELECT oDate, oName, oItem, oQty, oRemarks,
RANK() OVER (PARTITION BY oName ORDER BY oDate DESC) AS rk
FROM my_table) t
WHERE rk = 1
602392714
清零编程群