{"id":473,"date":"2024-08-11T15:10:03","date_gmt":"2024-08-11T15:10:03","guid":{"rendered":"https:\/\/humtechno.com\/intro\/?p=473"},"modified":"2024-08-11T15:11:44","modified_gmt":"2024-08-11T15:11:44","slug":"check-duplicate-records-in-table","status":"publish","type":"post","link":"https:\/\/humtechno.com\/intro\/2024\/08\/11\/check-duplicate-records-in-table\/","title":{"rendered":"Check Duplicate Records in Table"},"content":{"rendered":"\n\n\n\n<p><strong>Example<\/strong> <\/p>\n\n<p>SELECT COUNT(<em>), PARENT_KEY, SEQ, PARENT_ATTRIB, ACTEXEPK FROM CSM.NS_BPPACTIVITYEXE GROUP BY PARENT_KEY, SEQ, PARENT_ATTRIB, ACTEXEPK HAVING COUNT(<\/em>)&gt;1;<\/p>\n\n<p>Use those column in Select and Group by may have duplicate records<\/p>\n\n\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":44,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"pagelayer_contact_templates":[],"_pagelayer_content":"","footnotes":""},"categories":[5,39,3,38,4],"tags":[62,63],"class_list":["post-473","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ms-sql","category-my-sql","category-oracle","category-postgresql","category-sql-server","tag-check-duplicate-records","tag-duplicate-records"],"_links":{"self":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts\/473","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/comments?post=473"}],"version-history":[{"count":2,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts\/473\/revisions"}],"predecessor-version":[{"id":475,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts\/473\/revisions\/475"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/media\/44"}],"wp:attachment":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/media?parent=473"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/categories?post=473"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/tags?post=473"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}