select c.object_id, c.total_time,c.total_count
from (select t.*, row_number() over(partition by t.object_id order by t.total_time desc) rn from t_dcmt_dbobj_log t) c
where rn = 1
select c.object_id, c.total_time,c.total_count
from (select t.*, row_number() over(partition by t.object_id order by t.total_time desc) rn from t_dcmt_dbobj_log t) c
where rn = 1