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);
Sur cette page du site, vous pouvez voir la vidéo en ligne Delete Duplicate Records from Oracle Table using SQL durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Simple Oracle DB 19 mars 2020, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 358 fois et il a aimé 3 téléspectateurs. Bon visionnage!
