{"id":176,"date":"2022-02-14T16:51:07","date_gmt":"2022-02-14T16:51:07","guid":{"rendered":"https:\/\/openquery.com\/?p=176"},"modified":"2022-02-28T13:57:44","modified_gmt":"2022-02-28T13:57:44","slug":"how-to-use-distinct-in-sql","status":"publish","type":"post","link":"https:\/\/openquery.com\/how-to-use-distinct-in-sql\/","title":{"rendered":"How To Use Distinct In SQL"},"content":{"rendered":"\n<p>SQL is a programming language now used by software developers across the world. <\/p>\n\n\n\n<p>The language is used to create relational databases, which can help to store structured data and information. <\/p>\n\n\n\n<p>However, this does not mean that SQL is free from negative criticism, as there may come a situation when you have multiple records with duplicate data.<\/p>\n\n\n\n<p>Because of this, many developers use Distinct to <a href=\"https:\/\/openquery.com\/how-to-remove-duplicates-in-sql\/\" target=\"_blank\" rel=\"noopener\">remove duplicate<\/a> rows from a table or query, which helps to recover only unique records.<\/p>\n\n\n\n<p>In the article below, we are going to teach you how to use Distinct in SQL. So that you can use the keyword to recover specific data. <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"569\" src=\"https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/How-To-Use-Distinct-In-SQL-1024x569.jpg\" alt=\"How To Use Distinct In SQL\" class=\"wp-image-178\" srcset=\"https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/How-To-Use-Distinct-In-SQL-1024x569.jpg 1024w, https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/How-To-Use-Distinct-In-SQL-300x167.jpg 300w, https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/How-To-Use-Distinct-In-SQL-768x427.jpg 768w, https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/How-To-Use-Distinct-In-SQL.jpg 1200w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<p>Just follow our helpful guide and you will find everything you need to get started\u2026<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"what-is-sql\"><strong>What Is SQL?<\/strong><\/h2>\n\n\n\n<p><a href=\"https:\/\/openquery.com\/how-to-write-sql-queries\/\" target=\"_blank\" rel=\"noopener\">SQL stands for Structured Query<\/a> Language. This programming language allows you to create databases and query them. <\/p>\n\n\n\n<p>If you want to become a data scientist or database developer, <a href=\"https:\/\/openquery.com\/how-long-does-it-take-to-learn-sql\/\" target=\"_blank\" rel=\"noopener\">learning SQL<\/a> is essential.<\/p>\n\n\n\n<p>The language is a powerful tool for querying structured data stored in relational databases. <\/p>\n\n\n\n<p>The syntax of SQL is similar to English, allowing programmers to write queries using simple commands.<\/p>\n\n\n\n<p>SQL has been around since the 1970s. It was originally developed by IBM to allow their customers to access their mainframe computers. <\/p>\n\n\n\n<p>Since then, it has evolved into a standard language used by almost every major software company.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"what-is-distinct\"><strong>What Is Distinct?<\/strong><\/h2>\n\n\n\n<p>Distinct is a keyword used to remove duplicate <a href=\"https:\/\/openquery.com\/how-can-we-get-the-number-of-records-or-rows-in-a-table-using-mysql\/\" target=\"_blank\" rel=\"noopener\">rows from a table<\/a> or query result. The problem is that it only removes duplicates where the values match exactly. <\/p>\n\n\n\n<p>This means that if two records contain the same value for a particular column, they won\u2019t get removed.<\/p>\n\n\n\n<p>Because of this, Distinct is a very useful feature of SQL. It helps us to reduce the number of rows returned by a <a href=\"https:\/\/openquery.com\/how-to-write-sql-queries\/\" target=\"_blank\" rel=\"noopener\">query without having to write<\/a> additional code. <\/p>\n\n\n\n<p>For example, suppose we want to select all the names of employees who have worked for at least five years. We can use the distinct keyword to ensure that no employee appears twice.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"how-to-use-distinct-in-sql\"><strong>How To Use Distinct In SQL<\/strong><\/h2>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"569\" src=\"https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/How-To-Use-Distinct-In-SQL-1-1024x569.jpg\" alt=\"How To Use Distinct In SQL\" class=\"wp-image-179\" srcset=\"https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/How-To-Use-Distinct-In-SQL-1-1024x569.jpg 1024w, https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/How-To-Use-Distinct-In-SQL-1-300x167.jpg 300w, https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/How-To-Use-Distinct-In-SQL-1-768x427.jpg 768w, https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/How-To-Use-Distinct-In-SQL-1.jpg 1200w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<p>Distinct can be used to remove duplicate rows from a table. For example, if we had a table with three columns: name, age, and gender, then we could write a query like this: SELECT DISTINCT name FROM people.<\/p>\n\n\n\n<p>The keyword is used in conjunction with the Select keyword and is helpful when avoiding duplicate values in columns or tables.<\/p>\n\n\n\n<p>The unique values are recovered when we use the Distinct keyword:<\/p>\n\n\n\n<ul><li>SELECT DISTINCT recovers only distinct (or different) values.<\/li><li>DISTINCT removes duplicate values from the table.<\/li><li>DISTINCT can be used in conjunction with aggregates such as: COUNT, AVG and MAX.<\/li><li>DISTINCT operates with a single column.<\/li><li>DISTINCT does not support multiple columns.<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"syntax\"><strong>Syntax<\/strong><\/h2>\n\n\n\n<p>SELECT DISTINCT expressions FROM tables [WHERE conditions]<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"parameters\"><strong>Parameters<\/strong><\/h3>\n\n\n\n<p><strong>Expressions<\/strong>: This refers to the columns or calculations that you want to recover.<\/p>\n\n\n\n<p><strong>Tables<\/strong>: This is the table where we want to recover the data. There is only one table in the FROM clause.<\/p>\n\n\n\n<p><strong>WHERE Conditions<\/strong>: This refers to the conditions for the selected records and is optional.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"things-to-remember\"><strong>Things To Remember<\/strong><\/h2>\n\n\n\n<ul><li>When one expression is operated in the DISTINCT clause the query will return the unique values of the expressions.<\/li><li>The query will recover the unique records for the listed expressions if more than one expression is provided in the DISTINCT clause.<\/li><li>In SQL, the DISTINCT clause will not ignore the NULL values. So when using the DISTINCT clause in SQL, the result will include NULL as a distinct value.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"example\"><strong>Example<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>ID<\/strong><\/td><td><strong>Name&nbsp;<\/strong><\/td><td><strong>Age<\/strong><\/td><td><strong>Gender&nbsp;<\/strong><\/td><td><strong>Salary<\/strong><\/td><\/tr><tr><td>001<\/td><td>John<\/td><td>25<\/td><td>M<\/td><td>18000<\/td><\/tr><tr><td>002<\/td><td>Tina<\/td><td>30<\/td><td>F<\/td><td>22000<\/td><\/tr><tr><td>003<\/td><td>Ryan<\/td><td>26<\/td><td>M<\/td><td>20000<\/td><\/tr><tr><td>004<\/td><td>Raden&nbsp;<\/td><td>22<\/td><td>F<\/td><td>18000<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Now, let&#8217;s use the SELECT query down below to return the duplicate salary records.&nbsp;<\/p>\n\n\n\n<p>SQL&gt; SELECT salary FROM employees ORDER BY salary;<\/p>\n\n\n\n<p>When the above query has been executed, it will recover all the records including duplicate data. In the table above, the salary of John and Raden is the same 18000.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>Salary<\/strong><\/td><\/tr><tr><td>18000<\/td><\/tr><tr><td>22000<\/td><\/tr><tr><td>20000<\/td><\/tr><tr><td>18000<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Now, let&#8217;s use the DISTINCT keyword with the query above.&nbsp;<\/p>\n\n\n\n<p>SQL&gt; SELECT DISTINCT salary FROM employees ORDER BY salary;&nbsp;<\/p>\n\n\n\n<p>When the above query has been executed, it will remove the duplicate records from the table and show the following result:&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>Salary<\/strong><\/td><\/tr><tr><td>18000<\/td><\/tr><tr><td>22000<\/td><\/tr><tr><td>20000<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"how-to-find-unique-values-example\"><strong>How To Find Unique Values (Example)&nbsp;<\/strong><\/h2>\n\n\n\n<p>Let&#8217;s take a look at the DISTINCT clause and how it can be used to find unique values within one column in the table.&nbsp;<\/p>\n\n\n\n<p>In this example, we have compiled a list of suppliers using the following data to organize them:&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>ID<\/strong><\/td><td><strong>Supplier<\/strong><\/td><td><strong>Product&nbsp;<\/strong><\/td><td><strong>State<\/strong><\/td><\/tr><tr><td>100<\/td><td>Sunfresh Goods<\/td><td>Fruit&nbsp;<\/td><td>Florida&nbsp;<\/td><\/tr><tr><td>200<\/td><td>Rainbow Supplies<\/td><td>Craft<\/td><td>Washington<\/td><\/tr><tr><td>300<\/td><td>Julie&#8217;s Botanics&nbsp;<\/td><td>Plants<\/td><td>Florida&nbsp;<\/td><\/tr><tr><td>400<\/td><td>Seafresh Treats<\/td><td>Fish<\/td><td>Maine&nbsp;<\/td><\/tr><tr><td>500<\/td><td>Inkspot Press&nbsp;<\/td><td>Books<\/td><td>California&nbsp;<\/td><\/tr><tr><td>600<\/td><td>Good Time Spirits&nbsp;<\/td><td>Alcohol<\/td><td>Georgia&nbsp;<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>By using the following SELECT DISTINCT query, we are going to find the unique states from the table above.&nbsp;<\/p>\n\n\n\n<p>SELECT DISTINCT state FROM suppliers ORDER BY state;<\/p>\n\n\n\n<p>When the query has been executed, it will recover the unique states from the table and show the following result:&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>State<\/strong><\/td><\/tr><tr><td>Washington&nbsp;<\/td><\/tr><tr><td>Maine&nbsp;<\/td><\/tr><tr><td>California&nbsp;<\/td><\/tr><tr><td>Georgia&nbsp;<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"how-to-find-unique-values-in-multiple-columns-example\"><strong>How To Find Unique Values In Multiple Columns (Example)&nbsp;<\/strong><\/h2>\n\n\n\n<p>The SQL DISTINCT clause can be used to remove duplicate records from many fields in the SELECT statement.&nbsp;<\/p>\n\n\n\n<p>In this example, we have compiled a list of companies using the following data to organize them.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>ID<\/strong><\/td><td><strong>Company<\/strong><\/td><td><strong>City&nbsp;<\/strong><\/td><td><strong>State&nbsp;<\/strong><\/td><\/tr><tr><td>470<\/td><td>Microsoft&nbsp;<\/td><td>Redmond<\/td><td>Washington<\/td><\/tr><tr><td>471<\/td><td>HCL&nbsp;<\/td><td>Redwood City&nbsp;<\/td><td>California&nbsp;<\/td><\/tr><tr><td>472<\/td><td>Zomato Foods<\/td><td>Springdale&nbsp;<\/td><td>Arkansas&nbsp;<\/td><\/tr><tr><td>473<\/td><td>Wipro&nbsp;<\/td><td>Redwood City&nbsp;<\/td><td>California&nbsp;<\/td><\/tr><tr><td>474<\/td><td>Flowers Company<\/td><td>Thomasville&nbsp;<\/td><td>Georgia&nbsp;<\/td><\/tr><tr><td>475<\/td><td>Adani&nbsp;<\/td><td>Westlake Village&nbsp;<\/td><td>California&nbsp;<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>By using the following SELECT DISTINCT query, we are going to recover each unique city and state combination.&nbsp;<\/p>\n\n\n\n<p>SELECT DISTINCT city, state FROM company ORDER BY city, state;<\/p>\n\n\n\n<p>When the query has been executed, it will recover the unique city and state combinations and show the following result:&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>City&nbsp;<\/strong><\/td><td><strong>State&nbsp;<\/strong><\/td><\/tr><tr><td>Redmond<\/td><td>Washington&nbsp;<\/td><\/tr><tr><td>Redwood City&nbsp;<\/td><td>California&nbsp;<\/td><\/tr><tr><td>Springdale<\/td><td>Arkansas&nbsp;<\/td><\/tr><tr><td>Thomasville&nbsp;<\/td><td>Georgia&nbsp;<\/td><\/tr><tr><td>Westlake Village&nbsp;<\/td><td>California&nbsp;<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"how-distinct-clauses-handle-null-values-example\"><strong>How Distinct Clauses Handle Null Values (Example)&nbsp;<\/strong><\/h2>\n\n\n\n<p>In SQL, the DISTINCT clause considers NULL to the unique value. In this example, we have compiled a list of foods using the following data to organize them:&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>ID<\/strong><\/td><td><strong>Food<\/strong><\/td><td><strong>Category<\/strong><\/td><\/tr><tr><td>1<\/td><td>Steak&nbsp;<\/td><td>55<\/td><\/tr><tr><td>2<\/td><td>Donuts&nbsp;<\/td><td>55<\/td><\/tr><tr><td>3<\/td><td>Mango<\/td><td>NULL<\/td><\/tr><tr><td>4<\/td><td>Burgers&nbsp;<\/td><td>70<\/td><\/tr><tr><td>5<\/td><td>Candy&nbsp;<\/td><td>35<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>By using the following SELECT DISTINCT query, we are going to recover the unique values from the table, which should include the null value.&nbsp;<\/p>\n\n\n\n<p>SELECT DISTINCT id FROM food ORDER BY category;<\/p>\n\n\n\n<p>When the query has been executed, it will recover the unique values with the null value also being included in the results:&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>Category&nbsp;<\/strong><\/td><\/tr><tr><td>NULL<\/td><\/tr><tr><td>35<\/td><\/tr><tr><td>55<\/td><\/tr><tr><td>70<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"final-thoughts\"><strong>Final Thoughts&nbsp;<\/strong><\/h2>\n\n\n\n<p>Using Distinct in SQL may sound complicated, but it is a great way to recover unique values and remove duplicate data.&nbsp;<\/p>\n\n\n\n<p>Fortunately, the programming language uses a similar syntax to English and can be used to make simple commands.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<div class=\"container-lazyload preview-lazyload container-youtube js-lazyload--not-loaded\"><a href=\"https:\/\/www.youtube.com\/watch?v=aE-NwBnsyDQ\" class=\"lazy-load-youtube preview-lazyload preview-youtube\" data-video-title=\"Using DISTINCT in SQL\" title=\"Play video &quot;Using DISTINCT in SQL&quot;\">https:\/\/www.youtube.com\/watch?v=aE-NwBnsyDQ<\/a><noscript>Video can&#8217;t be loaded because JavaScript is disabled: <a href=\"https:\/\/www.youtube.com\/watch?v=aE-NwBnsyDQ\" title=\"Using DISTINCT in SQL\">Using DISTINCT in SQL (https:\/\/www.youtube.com\/watch?v=aE-NwBnsyDQ)<\/a><\/noscript><\/div>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>SQL is a programming language now used by software developers across the world. The language is used to create relational databases, which can help to store structured data and information. However, this does not mean that SQL is free from negative criticism, as there may come a situation when you have multiple records with duplicate &#8230; <a title=\"How To Use Distinct In SQL\" class=\"read-more\" href=\"https:\/\/openquery.com\/how-to-use-distinct-in-sql\/\" aria-label=\"More on How To Use Distinct In SQL\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":178,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[7],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.11 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Use Distinct In SQL - Open Query<\/title>\n<meta name=\"description\" content=\"If you are an aspiring database developer, then you need to know how to use Distinct in SQL. Just take a look at our article and everything you need to get started.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/openquery.com\/how-to-use-distinct-in-sql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Use Distinct In SQL - Open Query\" \/>\n<meta property=\"og:description\" content=\"If you are an aspiring database developer, then you need to know how to use Distinct in SQL. Just take a look at our article and everything you need to get started.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/openquery.com\/how-to-use-distinct-in-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"Open Query\" \/>\n<meta property=\"article:published_time\" content=\"2022-02-14T16:51:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-02-28T13:57:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/How-To-Use-Distinct-In-SQL.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"667\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Albert Niall\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Albert Niall\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/openquery.com\/how-to-use-distinct-in-sql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/openquery.com\/how-to-use-distinct-in-sql\/\"},\"author\":{\"name\":\"Albert Niall\",\"@id\":\"https:\/\/openquery.com\/#\/schema\/person\/95a786c4eec250fba9d6c71974a39656\"},\"headline\":\"How To Use Distinct In SQL\",\"datePublished\":\"2022-02-14T16:51:07+00:00\",\"dateModified\":\"2022-02-28T13:57:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/openquery.com\/how-to-use-distinct-in-sql\/\"},\"wordCount\":1177,\"publisher\":{\"@id\":\"https:\/\/openquery.com\/#organization\"},\"articleSection\":[\"Guides\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/openquery.com\/how-to-use-distinct-in-sql\/\",\"url\":\"https:\/\/openquery.com\/how-to-use-distinct-in-sql\/\",\"name\":\"How To Use Distinct In SQL - Open Query\",\"isPartOf\":{\"@id\":\"https:\/\/openquery.com\/#website\"},\"datePublished\":\"2022-02-14T16:51:07+00:00\",\"dateModified\":\"2022-02-28T13:57:44+00:00\",\"description\":\"If you are an aspiring database developer, then you need to know how to use Distinct in SQL. Just take a look at our article and everything you need to get started.\",\"breadcrumb\":{\"@id\":\"https:\/\/openquery.com\/how-to-use-distinct-in-sql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/openquery.com\/how-to-use-distinct-in-sql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/openquery.com\/how-to-use-distinct-in-sql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/openquery.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Use Distinct In SQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/openquery.com\/#website\",\"url\":\"https:\/\/openquery.com\/\",\"name\":\"Open Query\",\"description\":\"Everything about IT\",\"publisher\":{\"@id\":\"https:\/\/openquery.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/openquery.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/openquery.com\/#organization\",\"name\":\"Open Query\",\"url\":\"https:\/\/openquery.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/openquery.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/cropped-openquerylogo.png\",\"contentUrl\":\"https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/cropped-openquerylogo.png\",\"width\":1016,\"height\":323,\"caption\":\"Open Query\"},\"image\":{\"@id\":\"https:\/\/openquery.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/openquery.com\/#\/schema\/person\/95a786c4eec250fba9d6c71974a39656\",\"name\":\"Albert Niall\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/openquery.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/4728d76122b10a705d1e313fb3a924de?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/4728d76122b10a705d1e313fb3a924de?s=96&d=mm&r=g\",\"caption\":\"Albert Niall\"},\"description\":\"Hi, I\u2019m Albert Niall, and I want people to make the most out of their online presence and use it to their advantage. Here at Open Query I want to make it as easy as possible for you to learn about topics that might not be easily accessible elsewhere online. I don\u2019t know about you, but I haven\u2019t seen many other websites talking about the MariaDB Foundation and its updates. That\u2019s what makes Open Query truly unique. While others might assume everyone knows this information already automatically, I am filling my online resource to help.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Use Distinct In SQL - Open Query","description":"If you are an aspiring database developer, then you need to know how to use Distinct in SQL. Just take a look at our article and everything you need to get started.","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:\/\/openquery.com\/how-to-use-distinct-in-sql\/","og_locale":"en_US","og_type":"article","og_title":"How To Use Distinct In SQL - Open Query","og_description":"If you are an aspiring database developer, then you need to know how to use Distinct in SQL. Just take a look at our article and everything you need to get started.","og_url":"https:\/\/openquery.com\/how-to-use-distinct-in-sql\/","og_site_name":"Open Query","article_published_time":"2022-02-14T16:51:07+00:00","article_modified_time":"2022-02-28T13:57:44+00:00","og_image":[{"width":1200,"height":667,"url":"https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/How-To-Use-Distinct-In-SQL.jpg","type":"image\/jpeg"}],"author":"Albert Niall","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Albert Niall","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/openquery.com\/how-to-use-distinct-in-sql\/#article","isPartOf":{"@id":"https:\/\/openquery.com\/how-to-use-distinct-in-sql\/"},"author":{"name":"Albert Niall","@id":"https:\/\/openquery.com\/#\/schema\/person\/95a786c4eec250fba9d6c71974a39656"},"headline":"How To Use Distinct In SQL","datePublished":"2022-02-14T16:51:07+00:00","dateModified":"2022-02-28T13:57:44+00:00","mainEntityOfPage":{"@id":"https:\/\/openquery.com\/how-to-use-distinct-in-sql\/"},"wordCount":1177,"publisher":{"@id":"https:\/\/openquery.com\/#organization"},"articleSection":["Guides"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/openquery.com\/how-to-use-distinct-in-sql\/","url":"https:\/\/openquery.com\/how-to-use-distinct-in-sql\/","name":"How To Use Distinct In SQL - Open Query","isPartOf":{"@id":"https:\/\/openquery.com\/#website"},"datePublished":"2022-02-14T16:51:07+00:00","dateModified":"2022-02-28T13:57:44+00:00","description":"If you are an aspiring database developer, then you need to know how to use Distinct in SQL. Just take a look at our article and everything you need to get started.","breadcrumb":{"@id":"https:\/\/openquery.com\/how-to-use-distinct-in-sql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/openquery.com\/how-to-use-distinct-in-sql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/openquery.com\/how-to-use-distinct-in-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/openquery.com\/"},{"@type":"ListItem","position":2,"name":"How To Use Distinct In SQL"}]},{"@type":"WebSite","@id":"https:\/\/openquery.com\/#website","url":"https:\/\/openquery.com\/","name":"Open Query","description":"Everything about IT","publisher":{"@id":"https:\/\/openquery.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/openquery.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/openquery.com\/#organization","name":"Open Query","url":"https:\/\/openquery.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/openquery.com\/#\/schema\/logo\/image\/","url":"https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/cropped-openquerylogo.png","contentUrl":"https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/cropped-openquerylogo.png","width":1016,"height":323,"caption":"Open Query"},"image":{"@id":"https:\/\/openquery.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/openquery.com\/#\/schema\/person\/95a786c4eec250fba9d6c71974a39656","name":"Albert Niall","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/openquery.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/4728d76122b10a705d1e313fb3a924de?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4728d76122b10a705d1e313fb3a924de?s=96&d=mm&r=g","caption":"Albert Niall"},"description":"Hi, I\u2019m Albert Niall, and I want people to make the most out of their online presence and use it to their advantage. Here at Open Query I want to make it as easy as possible for you to learn about topics that might not be easily accessible elsewhere online. I don\u2019t know about you, but I haven\u2019t seen many other websites talking about the MariaDB Foundation and its updates. That\u2019s what makes Open Query truly unique. While others might assume everyone knows this information already automatically, I am filling my online resource to help."}]}},"_links":{"self":[{"href":"https:\/\/openquery.com\/wp-json\/wp\/v2\/posts\/176"}],"collection":[{"href":"https:\/\/openquery.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/openquery.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/openquery.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/openquery.com\/wp-json\/wp\/v2\/comments?post=176"}],"version-history":[{"count":3,"href":"https:\/\/openquery.com\/wp-json\/wp\/v2\/posts\/176\/revisions"}],"predecessor-version":[{"id":226,"href":"https:\/\/openquery.com\/wp-json\/wp\/v2\/posts\/176\/revisions\/226"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/openquery.com\/wp-json\/wp\/v2\/media\/178"}],"wp:attachment":[{"href":"https:\/\/openquery.com\/wp-json\/wp\/v2\/media?parent=176"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/openquery.com\/wp-json\/wp\/v2\/categories?post=176"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/openquery.com\/wp-json\/wp\/v2\/tags?post=176"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}