删除重复记录,保存Id最大的一条DELETE FROM SHIP_INOUT_PORT_tmp WHERE mmsi IN ( SELECT mmsi FROM SHIP_INOUT_PORT_tmp GROUP BY mmsi ...

--删除主键级联删除唯一索引alter table CBS_AG_CNTR_MTHD drop CONSTRAINT PK_CBS_AG_CNTR_MTHD cascade drop index;--创建主键级联创建唯一索引alter table CBS_AG_CNTR_MTHDadd constraint PK_CBS_AG_CNTR_MTHD primary key (CNTR_PACKG_U...

用projectid 作为分组并按id排序，获取最新一条数据。 oracle 、 mysql 用法 select * from ( select row_number() over(partition by ProjectID order by [ID] desc ) as keyId,* from table ) as t where t.keyId = 1 ...