{"id":2445,"date":"2023-07-22T06:16:57","date_gmt":"2023-07-22T06:16:57","guid":{"rendered":"https:\/\/statorials.org\/id\/mongodb-menemukan-duplikat\/"},"modified":"2023-07-22T06:16:57","modified_gmt":"2023-07-22T06:16:57","slug":"mongodb-menemukan-duplikat","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/mongodb-menemukan-duplikat\/","title":{"rendered":"Bagaimana menemukan duplikat di mongodb"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut untuk menemukan dokumen dengan nilai duplikat di MongoDB:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>db.collection.aggregate([\n    {\" <span style=\"color: #ff0000;\">$group<\/span> \": { \"_id\": \" <span style=\"color: #ff0000;\">$field1<\/span> \", \"count\": { \" <span style=\"color: #ff0000;\">$sum<\/span> \": 1 } } },\n    {\" <span style=\"color: #ff0000;\">$match<\/span> \": {\"_id\" :{ \" <span style=\"color: #ff0000;\">$ne<\/span> \" : null } , \"count\" : {\" <span style=\"color: #ff0000;\">$gt<\/span> \": 1} } }, \n    {\" <span style=\"color: #ff0000;\">$project<\/span> \": {\"name\": \" <span style=\"color: #ff0000;\">$_id<\/span> \", \"_id\": 0} }\n])\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Inilah yang dilakukan sintaksis ini:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>Kelompokkan<\/strong> semua dokumen dengan nilai yang sama di kolom 1<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Cocokkan<\/strong> kelompok yang memiliki lebih dari satu dokumen<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Proyeksikan<\/strong> semua grup yang memiliki lebih dari satu dokumen<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Kueri khusus ini mencari nilai duplikat di kolom <strong>field1<\/strong> . Cukup edit nilai ini untuk mengubah bidang pencarian.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan sintaks ini dengan <span style=\"padding: 1px; border: 1px solid black;\">tim<\/span> koleksi dengan dokumen berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>db.teams.insertOne({team: \" <span style=\"color: #008000;\">Mavs<\/span> \", position: \" <span style=\"color: #008000;\">Guard<\/span> \", points: <span style=\"color: #ff0000;\">31<\/span> })<\/strong>\n<strong>db.teams.insertOne({team: \" <span style=\"color: #008000;\">Mavs<\/span> \", position: \" <span style=\"color: #008000;\">Guard<\/span> \", points: <span style=\"color: #ff0000;\">22<\/span> })<\/strong>\n<strong>db.teams.insertOne({team: \" <span style=\"color: #008000;\">Rockets<\/span> \", position: \" <span style=\"color: #008000;\">Center<\/span> \", points: <span style=\"color: #ff0000;\">19<\/span> })<\/strong>\n<strong>db.teams.insertOne({team: \" <span style=\"color: #008000;\">Rockets<\/span> \", position: \" <span style=\"color: #008000;\">Forward<\/span> \", points: <span style=\"color: #ff0000;\">26<\/span> })<\/strong>\n<strong>db.teams.insertOne({team: \" <span style=\"color: #008000;\">Cavs<\/span> \", position: \" <span style=\"color: #008000;\">Guard<\/span> \", points: <span style=\"color: #ff0000;\">33<\/span> })<\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Temukan dokumen dengan nilai duplikat<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kode berikut untuk menemukan semua nilai duplikat di kolom &#8220;tim&#8221;:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>db.teams.aggregate([\n    {\" <span style=\"color: #ff0000;\">$group<\/span> \": { \"_id\": \" <span style=\"color: #ff0000;\">$team<\/span> \", \"count\": { \" <span style=\"color: #ff0000;\">$sum<\/span> \": 1 } } },\n    {\" <span style=\"color: #ff0000;\">$match<\/span> \": {\"_id\" :{ \" <span style=\"color: #ff0000;\">$ne<\/span> \" : null } , \"count\" : {\" <span style=\"color: #ff0000;\">$gt<\/span> \": 1} } }, \n    {\" <span style=\"color: #ff0000;\">$project<\/span> \": {\"name\": \" <span style=\"color: #ff0000;\">$_id<\/span> \", \"_id\": 0} }\n])<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kueri ini mengembalikan hasil berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>{ name: 'Rockets' }\n{ name: 'Mavs' }<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Ini memberitahu kita bahwa nilai &#8220;Rockets&#8221; dan &#8220;Mavs&#8221; muncul beberapa kali di bidang &#8220;tim&#8221;.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kita cukup mengganti <strong>$team<\/strong> dengan <strong>$position<\/strong> untuk mencari nilai duplikat di bidang &#8220;posisi&#8221;:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>db.teams.aggregate([\n    {\" <span style=\"color: #ff0000;\">$group<\/span> \": { \"_id\": \" <span style=\"color: #ff0000;\">$position<\/span> \", \"count\": { \" <span style=\"color: #ff0000;\">$sum<\/span> \": 1 } } },\n    {\" <span style=\"color: #ff0000;\">$match<\/span> \": {\"_id\" :{ \" <span style=\"color: #ff0000;\">$ne<\/span> \" : null } , \"count\" : {\" <span style=\"color: #ff0000;\">$gt<\/span> \": 1} } }, \n    {\" <span style=\"color: #ff0000;\">$project<\/span> \": {\"name\": \" <span style=\"color: #ff0000;\">$_id<\/span> \", \"_id\": 0} }\n])<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kueri ini mengembalikan hasil berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>{ name: 'Guard' }\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Ini memberitahu kita bahwa \u201cPenjaga\u201d muncul beberapa kali di bidang \u201cposisi\u201d.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di MongoDB:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/mongodb-menambahkan-bidang\/\" target=\"_blank\" rel=\"noopener\">MongoDB: Cara menambahkan bidang baru ke koleksi<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kelompok-mongodb-berdasarkan-nomor\/\" target=\"_blank\" rel=\"noopener\">MongoDB: Cara mengelompokkan dan menghitung<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/grup-mongodb-berdasarkan-beberapa-bidang\/\" target=\"_blank\" rel=\"noopener\">MongoDB: Cara mengelompokkan berdasarkan beberapa bidang<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks berikut untuk menemukan dokumen dengan nilai duplikat di MongoDB: db.collection.aggregate([ {&#8221; $group &#8220;: { &#8220;_id&#8221;: &#8221; $field1 &#8220;, &#8220;count&#8221;: { &#8221; $sum &#8220;: 1 } } }, {&#8221; $match &#8220;: {&#8220;_id&#8221; :{ &#8221; $ne &#8221; : null } , &#8220;count&#8221; : {&#8221; $gt &#8220;: 1} } }, {&#8221; $project &#8220;: {&#8220;name&#8221;: [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cara menemukan duplikat di MongoDB \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menemukan nilai duplikat di MongoDB, dengan beberapa contoh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/mongodb-menemukan-duplikat\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menemukan duplikat di MongoDB \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menemukan nilai duplikat di MongoDB, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/mongodb-menemukan-duplikat\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T06:16:57+00:00\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/mongodb-menemukan-duplikat\/\",\"url\":\"https:\/\/statorials.org\/id\/mongodb-menemukan-duplikat\/\",\"name\":\"Cara menemukan duplikat di MongoDB \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T06:16:57+00:00\",\"dateModified\":\"2023-07-22T06:16:57+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menemukan nilai duplikat di MongoDB, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/mongodb-menemukan-duplikat\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/mongodb-menemukan-duplikat\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/mongodb-menemukan-duplikat\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana menemukan duplikat di mongodb\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara menemukan duplikat di MongoDB \u2013 Statologi","description":"Tutorial ini menjelaskan cara menemukan nilai duplikat di MongoDB, dengan beberapa contoh.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/statorials.org\/id\/mongodb-menemukan-duplikat\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menemukan duplikat di MongoDB \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menemukan nilai duplikat di MongoDB, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/mongodb-menemukan-duplikat\/","og_site_name":"Statorials","article_published_time":"2023-07-22T06:16:57+00:00","author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/mongodb-menemukan-duplikat\/","url":"https:\/\/statorials.org\/id\/mongodb-menemukan-duplikat\/","name":"Cara menemukan duplikat di MongoDB \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T06:16:57+00:00","dateModified":"2023-07-22T06:16:57+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menemukan nilai duplikat di MongoDB, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/mongodb-menemukan-duplikat\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/mongodb-menemukan-duplikat\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/mongodb-menemukan-duplikat\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana menemukan duplikat di mongodb"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2445"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=2445"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2445\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2445"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2445"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2445"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}