{"id":181,"date":"2021-07-09T17:07:02","date_gmt":"2021-07-09T15:07:02","guid":{"rendered":"https:\/\/alessandromasciadri.com\/?p=181"},"modified":"2022-01-27T23:39:43","modified_gmt":"2022-01-27T22:39:43","slug":"query-sql-per-selezionare-righe-duplicate","status":"publish","type":"post","link":"https:\/\/alessandromasciadri.com\/query-sql-per-selezionare-righe-duplicate\/","title":{"rendered":"Query SQL per selezionare righe duplicate"},"content":{"rendered":"\t\t<div data-akihiro-type=\"ama-post\" data-akihiro-id=\"181\" class=\"akihiro akihiro-181\" data-akihiro-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"akihiro-section akihiro-top-section akihiro-element akihiro-element-2a97e509 akihiro-section-boxed akihiro-section-height-default akihiro-section-height-default\" data-id=\"2a97e509\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"akihiro-container akihiro-column-gap-default\">\n\t\t\t\t\t<div class=\"akihiro-column akihiro-col-100 akihiro-top-column akihiro-element akihiro-element-4f49a285\" data-id=\"4f49a285\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"akihiro-widget-wrap akihiro-element-populated\">\n\t\t\t\t\t\t<div class=\"akihiro-element akihiro-element-d457385 akihiro-widget akihiro-widget-text-editor\" data-id=\"d457385\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Lo scenario \u00e8 tanto semplice quanto comune: abbiamo una tabella e dobbiamo estrarre i record duplicati.<\/p>\n<p><!-- \/wp:paragraph --><!-- wp:paragraph --><\/p>\n<p>Too easy! Sicuramente sar\u00e0 venuto in mente un bel SELECT NOT DISTINCT, che ovviamente non funzioner\u00e0.<\/p>\n<p><!-- \/wp:paragraph --><!-- wp:paragraph --><\/p>\n<p>Per questo, lascio qui sotto una semplice sottoquery che fa proprio al caso nostro. Ora si, too easy!<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-e1d4778 akihiro-widget akihiro-widget-code-highlight\" data-id=\"e1d4778\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-sql line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-sql\">\n\t\t\t\t\t<xmp>SELECT email, telefono, nome, cognome\nFROM clienti\nWHERE email IN (\n    SELECT email\n    FROM clienti\n    GROUP BY email\n    HAVING COUNT(*) > 1);<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-8604572 akihiro-widget akihiro-widget-heading\" data-id=\"8604572\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t<h2 class=\"akihiro-heading-title akihiro-size-default\">Conclusione<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-7d62f92 akihiro-widget akihiro-widget-text-editor\" data-id=\"7d62f92\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>In questo articolo viene illustrato come selezionare le righe duplicate in una tabella mediante una query SQL.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Lo scenario \u00e8 tanto semplice quanto comune: abbiamo una tabella e dobbiamo estrarre i record duplicati. Too easy! Sicuramente sar\u00e0 venuto in mente un bel SELECT NOT DISTINCT, che ovviamente non funzioner\u00e0. Per questo, lascio qui sotto una semplice sottoquery che fa proprio al caso nostro. Ora si, too easy! SELECT email, telefono, nome, cognome [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[16],"class_list":["post-181","post","type-post","status-publish","format-standard","hentry","category-programmazione","tag-sql"],"_links":{"self":[{"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/posts\/181","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/comments?post=181"}],"version-history":[{"count":4,"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/posts\/181\/revisions"}],"predecessor-version":[{"id":353,"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/posts\/181\/revisions\/353"}],"wp:attachment":[{"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/media?parent=181"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/categories?post=181"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/tags?post=181"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}