老铁们这个能这样做吗?我知道其他做法,但是想试试这个。 Select * from (Select BussnissLogsID, UserID, HappeningTime, rank() over (partition by UserID order by HappeningTime desc) as r from BussnissLogs) where r =1