取出分组后每组的第一条记录(no group by)

SELECT * FROM JobLog A

WHERE JobLogId in

(SELECT TOP 1 JobLogId FROM JobLog WHERE A.FunctionId = FunctionId ORDER BY OperateTime DESC)