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);
На этой странице сайта вы можете посмотреть видео онлайн Delete Duplicate Records from Oracle Table using SQL длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь Simple Oracle DB 19 Март 2020, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 358 раз и оно понравилось 3 зрителям. Приятного просмотра!
