{"id":22184,"date":"2018-08-09T04:00:30","date_gmt":"2018-08-09T04:00:30","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=22184"},"modified":"2021-03-10T18:27:25","modified_gmt":"2021-03-10T12:57:25","slug":"distinct-keyword-in-sql","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/distinct-keyword-in-sql\/","title":{"rendered":"Distinct Keyword in SQL | SQL Select Distinct"},"content":{"rendered":"<p>SQL, which goes by the full form Structured Query Language, is a programming and a query language used to transact and query a database. We will discuss the DISTINCT keyword this time.<\/p>\n<p>We use the DISTINCT keyword when we need non-repetitive data in return for a query.<\/p>\n<p>In simple words, we can think of a DISTINCT keyword like the set, i.e., like a set deletes all the repetitive data, distinct keywords remove the repetitions in the data.<\/p>\n<h3>Why do we use the DISTINCT keyword?<\/h3>\n<p>The DISTINCT keyword is used to get distinct or different values from the query as output. We mostly use the DISTINCT keyword with the SELECT statement to obtain unique data.<\/p>\n<p>Distinct keyword is used whenever we need to find data that is not shared among all the other data stored in the database.<\/p>\n<p>Also, the columns contain many instances of duplicate data to remove these; we use distinct keywords in our SQL query.<\/p>\n<h3>Demo Database<\/h3>\n<p>We are using the <strong>DataFlair_Employee<\/strong> data, which contains five columns :<\/p>\n<ul>\n<li>Name of Employee (name_emp)<\/li>\n<li>Post of the employee (post_emp)<\/li>\n<li>Email (email)<\/li>\n<li>Age (age)<\/li>\n<li>Salary (salary)<\/li>\n<\/ul>\n<p>First, let us inspect the contents of our database using the SELECT query.<\/p>\n<p><strong>Syntax:\u00a0<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT * FROM tableName ;<\/pre>\n<p><strong>Query:\u00a0<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT * FROM dataflair_employee ;<\/pre>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/View-the-demo-database-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-86825\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/View-the-demo-database-1.png\" alt=\"View the demo database (1)\" width=\"1920\" height=\"1030\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/View-the-demo-database-1.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/View-the-demo-database-1-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/View-the-demo-database-1-1024x549.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/View-the-demo-database-1-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/View-the-demo-database-1-768x412.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/View-the-demo-database-1-1536x824.png 1536w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/View-the-demo-database-1-720x386.png 720w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/View-the-demo-database-1-520x279.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/View-the-demo-database-1-320x172.png 320w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p>This is what our DataFlair_Employee database looks like. As we can observe, we have multiple columns with repetitive data present.<\/p>\n<p>To avoid this, we can use the DISTINCT keyword while writing the Query so that we can get the output of all the unique values.<\/p>\n<h3>DISTINCT Keyword in SQL<\/h3>\n<p>We use the DISTINCT keyword in our SELECT query to get the unique output of the query transaction we do on our database.<br \/>\n<strong>Syntax:\u00a0<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT DISTINCT column1, column2, \u2026 FROM table_name;<\/pre>\n<h3>Parameters or Arguments in DISTINCT keyword of SQL<\/h3>\n<p>While writing a SQL query with the DISTINCT keyword, we use various parameters and arguments which are as follows:<\/p>\n<ul>\n<li><strong>Column Name:<\/strong> We enter the name of the column whose unique data we need to fetch.<\/li>\n<li><strong>Conditional:<\/strong> We input the condition on whose satisfaction we need the output of unique values.<\/li>\n<li><strong>Table Name:<\/strong> We enter the name of the table from which we need to fetch the unique records<\/li>\n<li><strong>WHERE clause:<\/strong> We use where clause to get data satisfying specific conditions within the records.<\/li>\n<\/ul>\n<h3>Type 1: Finding a unique value in a column<\/h3>\n<p>Let us find out all the unique posts available in DataFlair by executing a SELECT query with the DISTINCT keyword. The syntax and query are as follows:<\/p>\n<p><strong>Syntax:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT DISTINCT column1 FROM table_name;\r\n\r\n<\/pre>\n<p><strong>Query:\u00a0<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT DISTINCT post_emp  FROM DataFlair_Employee ;\r\n<\/pre>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Type-1-Distinct-query.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-86826\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Type-1-Distinct-query.png\" alt=\"Distinct Query in SQL\" width=\"1920\" height=\"1030\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Type-1-Distinct-query.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Type-1-Distinct-query-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Type-1-Distinct-query-1024x549.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Type-1-Distinct-query-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Type-1-Distinct-query-768x412.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Type-1-Distinct-query-1536x824.png 1536w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Type-1-Distinct-query-720x386.png 720w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Type-1-Distinct-query-520x279.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Type-1-Distinct-query-320x172.png 320w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p>Here we can see all the available Employee posts available in DataFlair.<\/p>\n<h3>Type 2: Use the DISTINCT keyword to count the unique entries in a column<\/h3>\n<p>Let us count the unique names of employees working in DataFlair. We can do this by executing a Select query and passing the column name whose count of unique elements we need to find. The Syntax and query are as follows:<\/p>\n<p><strong>Syntax:\u00a0<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT COUNT(DISTINCT columnName1) FROM tableName;<\/pre>\n<p><strong>Query:\u00a0<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT COUNT(DISTINCT name_emp) FROM DataFlair_Employee;<\/pre>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Type-2-distinct-query.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-86827\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Type-2-distinct-query.png\" alt=\"Type 2 distinct query\" width=\"1920\" height=\"1030\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Type-2-distinct-query.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Type-2-distinct-query-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Type-2-distinct-query-1024x549.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Type-2-distinct-query-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Type-2-distinct-query-768x412.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Type-2-distinct-query-1536x824.png 1536w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Type-2-distinct-query-720x386.png 720w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Type-2-distinct-query-520x279.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Type-2-distinct-query-320x172.png 320w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p>We can see the count of unique names in our database after executing the above-stated query.<\/p>\n<h3>Type 3: Counting all the unique entries of data in the database<\/h3>\n<p>Let us count the total number of positions on which the employees in DataFlair are working. To obtain the count, we need to execute the Count keyword on the Select query with a Distinct keyword.<\/p>\n<p><strong>Syntax:\u00a0<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT Count(DISTINCT columnName) FROM tableName ;<\/pre>\n<p><strong>Query:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT Count(DISTINCT post_emp) FROM dataflair_employee ;<\/pre>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Type-3-distinct-query.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-86828\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Type-3-distinct-query.png\" alt=\"Type 3 distinct query\" width=\"1920\" height=\"1030\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Type-3-distinct-query.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Type-3-distinct-query-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Type-3-distinct-query-1024x549.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Type-3-distinct-query-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Type-3-distinct-query-768x412.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Type-3-distinct-query-1536x824.png 1536w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Type-3-distinct-query-720x386.png 720w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Type-3-distinct-query-520x279.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Type-3-distinct-query-320x172.png 320w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p>Here, we can see the count of all unique Employee posts in DataFlair.<\/p>\n<h3>Type 4: Handling NULL values by the DISTINCT keyword<\/h3>\n<p>Let us first insert some NULL values in our database, and view our database again.<\/p>\n<p><strong>Syntax:\u00a0<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT * FROM table_name;<\/pre>\n<p><strong>Query:\u00a0<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT * FROM DataFlair_Employee ;<\/pre>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/View-the-new-database-for-null-values.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-86833\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/View-the-new-database-for-null-values.png\" alt=\"View the new database for null values\" width=\"1920\" height=\"968\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/View-the-new-database-for-null-values.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/View-the-new-database-for-null-values-300x151.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/View-the-new-database-for-null-values-1024x516.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/View-the-new-database-for-null-values-150x76.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/View-the-new-database-for-null-values-768x387.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/View-the-new-database-for-null-values-1536x774.png 1536w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/View-the-new-database-for-null-values-720x363.png 720w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/View-the-new-database-for-null-values-520x262.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/View-the-new-database-for-null-values-320x161.png 320w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p>We can see we have two columns in which we have a null value, now let us run them individually<br \/>\nSelect Distinct query on both the columns.<\/p>\n<h4>Example 1<\/h4>\n<p><strong>Syntax:\u00a0<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT DISTINCT column1 FROM table_name;<\/pre>\n<p><strong>Query:\u00a0<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT DISTINCT post_emp FROM DataFlair_Employee ;\r\n<\/pre>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/null-values-example-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-86829\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/null-values-example-1.png\" alt=\"SQL null values example 1\" width=\"1920\" height=\"1030\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/null-values-example-1.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/null-values-example-1-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/null-values-example-1-1024x549.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/null-values-example-1-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/null-values-example-1-768x412.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/null-values-example-1-1536x824.png 1536w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/null-values-example-1-720x386.png 720w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/null-values-example-1-520x279.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/null-values-example-1-320x172.png 320w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p>We observe that our null value is treated as a different value by the SQL query.<\/p>\n<h4>Example 2<\/h4>\n<p><strong>Syntax:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT DISTINCT column1 FROM table_name;\r\n<\/pre>\n<p><strong>Query:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT DISTINCT age FROM DataFlair_Employee ;\r\n<\/pre>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/null-values-example-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-86830\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/null-values-example-2.png\" alt=\"SQL Null Values \" width=\"1920\" height=\"1030\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/null-values-example-2.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/null-values-example-2-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/null-values-example-2-1024x549.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/null-values-example-2-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/null-values-example-2-768x412.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/null-values-example-2-1536x824.png 1536w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/null-values-example-2-720x386.png 720w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/null-values-example-2-520x279.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/null-values-example-2-320x172.png 320w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p>A similar case can be observed in the second example as well.<\/p>\n<h3>Summary<\/h3>\n<p>We have discussed what the DISTINCT keyword is and where do we use it. We have also studied the syntax and example of the DISTINCT keyword in various case scenarios.<\/p>\n<p>DISTINCT keyword allows us to fetch the unique data and also maintain its count using the COUNT keyword used in SQL queries.<\/p>\n<p>We can use this to preprocess data or to get a peek into the data and understand the significant data points as we are considering only the unique values.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQL, which goes by the full form Structured Query Language, is a programming and a query language used to transact and query a database. We will discuss the DISTINCT keyword this time. We use&#46;&#46;&#46;<\/p>\n","protected":false},"author":6,"featured_media":86824,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[66],"tags":[3980,3982,4373,12701,12702,13422,13446,13447,13548],"class_list":["post-22184","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql","tag-distinct-keyword-in-sql","tag-distinct-query-in-sql","tag-example-sql-distinct-keyword","tag-select-distinct","tag-select-distinct-mysql","tag-sql-count-distinct","tag-sql-distinct-count","tag-sql-distinct-keyword","tag-sql-server-distinct"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Distinct Keyword in SQL | SQL Select Distinct - DataFlair<\/title>\n<meta name=\"description\" content=\"Distinct Keyword in SQL,SQL Select distinct,SQL count unique values,SQL distinct example,dintinct query SQL,SQL server distinct,SQL count distinct,parameter\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/distinct-keyword-in-sql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Distinct Keyword in SQL | SQL Select Distinct - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Distinct Keyword in SQL,SQL Select distinct,SQL count unique values,SQL distinct example,dintinct query SQL,SQL server distinct,SQL count distinct,parameter\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/distinct-keyword-in-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-09T04:00:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-03-10T12:57:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Distinct-keyword.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Distinct Keyword in SQL | SQL Select Distinct - DataFlair","description":"Distinct Keyword in SQL,SQL Select distinct,SQL count unique values,SQL distinct example,dintinct query SQL,SQL server distinct,SQL count distinct,parameter","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:\/\/data-flair.training\/blogs\/distinct-keyword-in-sql\/","og_locale":"en_US","og_type":"article","og_title":"Distinct Keyword in SQL | SQL Select Distinct - DataFlair","og_description":"Distinct Keyword in SQL,SQL Select distinct,SQL count unique values,SQL distinct example,dintinct query SQL,SQL server distinct,SQL count distinct,parameter","og_url":"https:\/\/data-flair.training\/blogs\/distinct-keyword-in-sql\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-08-09T04:00:30+00:00","article_modified_time":"2021-03-10T12:57:25+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Distinct-keyword.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/distinct-keyword-in-sql\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/distinct-keyword-in-sql\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"Distinct Keyword in SQL | SQL Select Distinct","datePublished":"2018-08-09T04:00:30+00:00","dateModified":"2021-03-10T12:57:25+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/distinct-keyword-in-sql\/"},"wordCount":726,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/distinct-keyword-in-sql\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Distinct-keyword.jpg","keywords":["Distinct Keyword in SQL","distinct query in SQL","Example SQL Distinct Keyword","Select distinct *","Select distinct mySQL","SQL count distinct","SQL distinct count","SQL Distinct Keyword","SQL server distinct"],"articleSection":["SQL Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/distinct-keyword-in-sql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/distinct-keyword-in-sql\/","url":"https:\/\/data-flair.training\/blogs\/distinct-keyword-in-sql\/","name":"Distinct Keyword in SQL | SQL Select Distinct - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/distinct-keyword-in-sql\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/distinct-keyword-in-sql\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Distinct-keyword.jpg","datePublished":"2018-08-09T04:00:30+00:00","dateModified":"2021-03-10T12:57:25+00:00","description":"Distinct Keyword in SQL,SQL Select distinct,SQL count unique values,SQL distinct example,dintinct query SQL,SQL server distinct,SQL count distinct,parameter","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/distinct-keyword-in-sql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/distinct-keyword-in-sql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/distinct-keyword-in-sql\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Distinct-keyword.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Distinct-keyword.jpg","width":1200,"height":628,"caption":"SQL Distinct Keyword"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/distinct-keyword-in-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Searching for Groups of Scala Regex","item":"https:\/\/data-flair.training\/blogs\/tag\/searching-for-groups-of-scala-regex\/"},{"@type":"ListItem","position":3,"name":"Distinct Keyword in SQL | SQL Select Distinct"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"The DataFlair Team provides industry-driven content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our expert educators focus on delivering value-packed, easy-to-follow resources for tech enthusiasts and professionals.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam2\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/22184","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=22184"}],"version-history":[{"count":5,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/22184\/revisions"}],"predecessor-version":[{"id":86834,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/22184\/revisions\/86834"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/86824"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=22184"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=22184"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=22184"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}