删除表重复记录
select *
from tm_service_rela t1
where rowid not in
(select min(t.rowid)
from tm_service_rela t
group by t.tm_package_id, t.service_code);
select *
from tm_service_rela t1
where rowid >
(select min(t.rowid)
from tm_service_rela t
where t1.tm_package_id = t.tm_package_id and t1.service_code = t.service_code);
select *
from tm_service_rela t1
where rowid not in
(select min(t.rowid)
from tm_service_rela t
group by t.tm_package_id, t.service_code);
select *
from tm_service_rela t1
where rowid >
(select min(t.rowid)
from tm_service_rela t
where t1.tm_package_id = t.tm_package_id and t1.service_code = t.service_code);