※老鼠拧刀满街找猫※

select '新增字段' as "变更类型", '系统' as "信息系统名称", 'DEKBGMS' as "数据库名称", c.TABLE_NAME as "物理实体名称", (select men.COMMENTS from user_tab_comments men where men.Table_Name = c.Table_Name) as "物理实体描述", c.COLUMN_NA..

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