In this video we see how to deal with reverse pair duplicate data in SQL.

Two different methods are explained to identify and delete reverse pair duplicate from the table.

DDL for the table used :-

--table
--src_dest table

/*
create table src_dest(
source varchar(50),
destination varchar(50),
distance int
)

insert into src_dest(source,destination,distance)
values('Alaska','Albany',5166),
('Dover','Florida',1393),
('Illinois','Indiana',279),
('New Mexico','New York',2873),
('Albany','Alaska',5166),
('Ohio','Oklahoma',1383),
('Indiana','Illinois',279),
('Oklahoma','Ohio',1383),
('Frankfort','Georgia',695),
('Georgia','Frankfort',695)

*/

"Thanks for watching. If you liked this video, make sure to subscribe for more!”

#dataprojecthub
#data_project_hub

свернуть