Delete Duplicate Records from Oracle Table using SQL

Pubblicato il: 19 marzo 2020
sul canale di: 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);

In questa pagina del sito puoi guardare il video online Delete Duplicate Records from Oracle Table using SQL della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Simple Oracle DB 19 marzo 2020, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 358 volte e gli è piaciuto 3 spettatori. Buona visione!