{"id":23149,"date":"2024-03-16T00:53:28","date_gmt":"2024-03-16T00:53:28","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-is-distinct-used-in-mybatis-plus\/"},"modified":"2024-03-22T00:34:40","modified_gmt":"2024-03-22T00:34:40","slug":"how-is-distinct-used-in-mybatis-plus","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-is-distinct-used-in-mybatis-plus\/","title":{"rendered":"How is &#8216;distinct&#8217; used in MyBatis Plus?"},"content":{"rendered":"<p>In MyBatis Plus, the distinct method can be used to achieve deduplication. It can be used on QueryWrapper or LambdaQueryWrapper objects.<\/p>\n<p>Example usage:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-comment\">\/\/ \u4f7f\u7528QueryWrapper\u7684distinct\u65b9\u6cd5<\/span>\r\nQueryWrapper&lt;User&gt; queryWrapper = <span class=\"hljs-keyword\">new<\/span> <span class=\"hljs-title class_\">QueryWrapper<\/span>&lt;&gt;();\r\nqueryWrapper.select(<span class=\"hljs-string\">\"id\"<\/span>, <span class=\"hljs-string\">\"name\"<\/span>).distinct(<span class=\"hljs-literal\">true<\/span>).eq(<span class=\"hljs-string\">\"age\"<\/span>, <span class=\"hljs-number\">18<\/span>);\r\nList&lt;User&gt; userList = userMapper.selectList(queryWrapper);\r\n\r\n<span class=\"hljs-comment\">\/\/ \u4f7f\u7528LambdaQueryWrapper\u7684distinct\u65b9\u6cd5<\/span>\r\nLambdaQueryWrapper&lt;User&gt; lambdaQueryWrapper = <span class=\"hljs-keyword\">new<\/span> <span class=\"hljs-title class_\">LambdaQueryWrapper<\/span>&lt;&gt;();\r\nlambdaQueryWrapper.select(User::getId, User::getName).distinct(<span class=\"hljs-literal\">true<\/span>).eq(User::getAge, <span class=\"hljs-number\">18<\/span>);\r\nList&lt;User&gt; userList = userMapper.selectList(lambdaQueryWrapper);\r\n<\/code><\/pre>\n<p>In the above example, the distinct(true) method is used to eliminate duplicates from the query results and only return unique records. Specify the fields to be queried in the select method, and then add query conditions using the eq method.<\/p>\n<p>Note: The distinct method only removes duplicates from the specified fields; if no fields are specified, duplicates will be removed from all fields by default.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In MyBatis Plus, the distinct method can be used to achieve deduplication. It can be used on QueryWrapper or LambdaQueryWrapper objects. Example usage: \/\/ \u4f7f\u7528QueryWrapper\u7684distinct\u65b9\u6cd5 QueryWrapper&lt;User&gt; queryWrapper = new QueryWrapper&lt;&gt;(); queryWrapper.select(&#8220;id&#8221;, &#8220;name&#8221;).distinct(true).eq(&#8220;age&#8221;, 18); List&lt;User&gt; userList = userMapper.selectList(queryWrapper); \/\/ \u4f7f\u7528LambdaQueryWrapper\u7684distinct\u65b9\u6cd5 LambdaQueryWrapper&lt;User&gt; lambdaQueryWrapper = new LambdaQueryWrapper&lt;&gt;(); lambdaQueryWrapper.select(User::getId, User::getName).distinct(true).eq(User::getAge, 18); List&lt;User&gt; userList = userMapper.selectList(lambdaQueryWrapper); In the above example, [&hellip;]<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-23149","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How is &#039;distinct&#039; used in MyBatis Plus? - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-is-distinct-used-in-mybatis-plus\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How is &#039;distinct&#039; used in MyBatis Plus?\" \/>\n<meta property=\"og:description\" content=\"In MyBatis Plus, the distinct method can be used to achieve deduplication. It can be used on QueryWrapper or LambdaQueryWrapper objects. Example usage: \/\/ \u4f7f\u7528QueryWrapper\u7684distinct\u65b9\u6cd5 QueryWrapper&lt;User&gt; queryWrapper = new QueryWrapper&lt;&gt;(); queryWrapper.select(&quot;id&quot;, &quot;name&quot;).distinct(true).eq(&quot;age&quot;, 18); List&lt;User&gt; userList = userMapper.selectList(queryWrapper); \/\/ \u4f7f\u7528LambdaQueryWrapper\u7684distinct\u65b9\u6cd5 LambdaQueryWrapper&lt;User&gt; lambdaQueryWrapper = new LambdaQueryWrapper&lt;&gt;(); lambdaQueryWrapper.select(User::getId, User::getName).distinct(true).eq(User::getAge, 18); List&lt;User&gt; userList = userMapper.selectList(lambdaQueryWrapper); In the above example, [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-is-distinct-used-in-mybatis-plus\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-16T00:53:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-22T00:34:40+00:00\" \/>\n<meta name=\"author\" content=\"Olivia Parker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Olivia Parker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-is-distinct-used-in-mybatis-plus\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-is-distinct-used-in-mybatis-plus\/\"},\"author\":{\"name\":\"Olivia Parker\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9\"},\"headline\":\"How is &#8216;distinct&#8217; used in MyBatis Plus?\",\"datePublished\":\"2024-03-16T00:53:28+00:00\",\"dateModified\":\"2024-03-22T00:34:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-is-distinct-used-in-mybatis-plus\/\"},\"wordCount\":96,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-is-distinct-used-in-mybatis-plus\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-is-distinct-used-in-mybatis-plus\/\",\"name\":\"How is 'distinct' used in MyBatis Plus? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-16T00:53:28+00:00\",\"dateModified\":\"2024-03-22T00:34:40+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-is-distinct-used-in-mybatis-plus\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-is-distinct-used-in-mybatis-plus\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-is-distinct-used-in-mybatis-plus\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How is &#8216;distinct&#8217; used in MyBatis Plus?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9\",\"name\":\"Olivia Parker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g\",\"caption\":\"Olivia Parker\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/oliviaparker\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How is 'distinct' used in MyBatis Plus? - Blog - Silicon Cloud","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:\/\/www.silicloud.com\/blog\/how-is-distinct-used-in-mybatis-plus\/","og_locale":"en_US","og_type":"article","og_title":"How is 'distinct' used in MyBatis Plus?","og_description":"In MyBatis Plus, the distinct method can be used to achieve deduplication. It can be used on QueryWrapper or LambdaQueryWrapper objects. Example usage: \/\/ \u4f7f\u7528QueryWrapper\u7684distinct\u65b9\u6cd5 QueryWrapper&lt;User&gt; queryWrapper = new QueryWrapper&lt;&gt;(); queryWrapper.select(\"id\", \"name\").distinct(true).eq(\"age\", 18); List&lt;User&gt; userList = userMapper.selectList(queryWrapper); \/\/ \u4f7f\u7528LambdaQueryWrapper\u7684distinct\u65b9\u6cd5 LambdaQueryWrapper&lt;User&gt; lambdaQueryWrapper = new LambdaQueryWrapper&lt;&gt;(); lambdaQueryWrapper.select(User::getId, User::getName).distinct(true).eq(User::getAge, 18); List&lt;User&gt; userList = userMapper.selectList(lambdaQueryWrapper); In the above example, [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/how-is-distinct-used-in-mybatis-plus\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-16T00:53:28+00:00","article_modified_time":"2024-03-22T00:34:40+00:00","author":"Olivia Parker","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Olivia Parker","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-is-distinct-used-in-mybatis-plus\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-is-distinct-used-in-mybatis-plus\/"},"author":{"name":"Olivia Parker","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9"},"headline":"How is &#8216;distinct&#8217; used in MyBatis Plus?","datePublished":"2024-03-16T00:53:28+00:00","dateModified":"2024-03-22T00:34:40+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-is-distinct-used-in-mybatis-plus\/"},"wordCount":96,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-is-distinct-used-in-mybatis-plus\/","url":"https:\/\/www.silicloud.com\/blog\/how-is-distinct-used-in-mybatis-plus\/","name":"How is 'distinct' used in MyBatis Plus? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-16T00:53:28+00:00","dateModified":"2024-03-22T00:34:40+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-is-distinct-used-in-mybatis-plus\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-is-distinct-used-in-mybatis-plus\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-is-distinct-used-in-mybatis-plus\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How is &#8216;distinct&#8217; used in MyBatis Plus?"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9","name":"Olivia Parker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g","caption":"Olivia Parker"},"url":"https:\/\/www.silicloud.com\/blog\/author\/oliviaparker\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/23149","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=23149"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/23149\/revisions"}],"predecessor-version":[{"id":57110,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/23149\/revisions\/57110"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=23149"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=23149"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=23149"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}