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);
On this page of the site you can watch the video online Delete Duplicate Records from Oracle Table using SQL with a duration of hours minute second in good quality, which was uploaded by the user Simple Oracle DB 19 March 2020, share the link with friends and acquaintances, this video has already been watched 358 times on youtube and it was liked by 3 viewers. Enjoy your viewing!
