Delete Duplicate Records from Oracle Table using SQL
Delete Duplicate Records from Oracle Table using SQL
SQL used in Video:
select first_name, last_name, job_name
from users_table
order by first_name, last_name;
select rowid, first_name, last_name, job_name
from users_table
order by first_name, last_name;
select max(rowid) max_id, first_name, last_name, job_name
from users_table
group by first_name, last_name, job_name;
select tab.max_id
from (select max(rowid) max_id, first_name, last_name, job_name
from users_table
group by first_name, last_name, job_name) tab;
delete from users_table
where rowid not in (select tab.max_id
from (select max(rowid) max_id, first_name, last_name, job_name
from users_table
group by first_name, last_name, job_name) tab);
select employee_number, first_name, last_name, job_name
from users_table_num
order by first_name, last_name;
select rowid, employee_number, first_name, last_name, job_name
from users_table_num
order by first_name, last_name;
select max(rowid) max_id, max(employee_number) employee_number, first_name, last_name, job_name
from users_table_num
group by first_name, last_name, job_name;
select tab.max_id
from (select max(rowid) max_id, max(employee_number) employee_number, first_name, last_name, job_name
from users_table_num
group by first_name, last_name, job_name) tab;
delete from users_table_num
where rowid not in (select tab.max_id
from (select max(rowid) max_id, max(employee_number) employee_number, first_name, last_name, job_name
from users_table_num
group by first_name, last_name, job_name) tab);
En esta página del sitio puede ver el video en línea Delete Duplicate Records from Oracle Table using SQL de Duración hora minuto segunda en buena calidad , que subió el usuario Simple Oracle DB 19 marzo 2020, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 358 veces y le gustó 3 a los espectadores. Disfruta viendo!
