{"id":93,"date":"2014-05-10T12:04:00","date_gmt":"2014-05-10T11:04:00","guid":{"rendered":"https:\/\/debuggersspace.com\/index.php\/2014\/05\/10\/delete-duplicate-rows-in-sql\/"},"modified":"2014-05-10T12:04:00","modified_gmt":"2014-05-10T11:04:00","slug":"delete-duplicate-rows-in-sql","status":"publish","type":"post","link":"https:\/\/debuggersspace.com\/index.php\/2014\/05\/10\/delete-duplicate-rows-in-sql\/","title":{"rendered":"Delete Duplicate rows in SQL ?"},"content":{"rendered":"
\n
\n \t<\/i> Read Time:<\/span>34 Second <\/div>\n\n <\/div>
\n\/\/ Creating table and inserting some records<\/span>
\ncreate table email_list<\/span>
\n(<\/span>
\nname varchar(100),<\/span>
\nemail varchar(50)<\/span>
\n)<\/span>
\ngo<\/span>
\ninsert into email_list values (‘himanshu’, ‘him@gmail.com’);<\/span>
\ninsert into email_list values (‘prem’, ‘prem@gmail.com’);<\/span>
\ninsert into email_list values (‘himanshu’, ‘him@gmail.com’);<\/span>
\ninsert into email_list values (‘prem’, ‘prem@gmail.com’);<\/span>
\ninsert into email_list values (‘himanshu’, ‘him@gmail.com’);<\/span><\/p>\n
\n<\/span><\/a><\/div>\n


<\/span>
\n\/\/ Showing records<\/span>
\nselect * from email_list<\/span>
\norder by 1,2<\/span><\/p>\n

\n<\/span><\/a><\/div>\n


<\/span>
\n\/\/ <\/span>Deleting Duplicate rows<\/span><\/span>
\nwith list_duplicate( name, email, duplicate_count)as<\/span>
\n(select name, email, ROW_NUMBER() over(PARTITION By name , email order by name, email) as duplicate_count from email_list)<\/span>
\ndelete from list_duplicate where duplicate_count>1<\/span><\/p>\n

\n<\/span><\/a><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\/\/ Creating table and inserting some records create table email_list ( name varchar(100), email varchar(50) ) go insert into email_list values (‘himanshu’, ‘him@gmail.com’); insert into email_list values (‘prem’, ‘prem@gmail.com’); insert into email_list values (‘himanshu’, ‘him@gmail.com’); insert into email_list values (‘prem’, ‘prem@gmail.com’); insert into email_list values (‘himanshu’, ‘him@gmail.com’); \/\/ Showing records select * from email_list order […]<\/p>\n","protected":false},"author":43,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","footnotes":""},"categories":[27],"tags":[],"class_list":["post-93","post","type-post","status-publish","format-standard","hentry","category-sql"],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"Himanshu Namdeo","author_link":"https:\/\/debuggersspace.com\/author\/admin\/"},"uagb_comment_info":0,"uagb_excerpt":"\/\/ Creating table and inserting some records create table email_list ( name varchar(100), email varchar(50) ) go insert into email_list values (‘himanshu’, ‘him@gmail.com’); insert into email_list values (‘prem’, ‘prem@gmail.com’); insert into email_list values (‘himanshu’, ‘him@gmail.com’); insert into email_list values (‘prem’, ‘prem@gmail.com’); insert into email_list values (‘himanshu’, ‘him@gmail.com’); \/\/ Showing records select * from email_list order…","_links":{"self":[{"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/posts\/93"}],"collection":[{"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/users\/43"}],"replies":[{"embeddable":true,"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/comments?post=93"}],"version-history":[{"count":0,"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/posts\/93\/revisions"}],"wp:attachment":[{"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/media?parent=93"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/categories?post=93"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/tags?post=93"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}