Delete Duplicate Records from Oracle Table using SQL

Veröffentlicht am: 19 März 2020
auf dem Kanal: Simple Oracle DB

358

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);

Auf dieser Seite können Sie das Online-Video Delete Duplicate Records from Oracle Table using SQL mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Simple Oracle DB 19 März 2020 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 358 Mal angesehen und es wurde von 3 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!