{"id":27171,"date":"2022-12-01T11:00:36","date_gmt":"2022-12-01T11:00:36","guid":{"rendered":"https:\/\/kb.hostatom.com\/?p=27171"},"modified":"2025-11-11T01:37:24","modified_gmt":"2025-11-11T01:37:24","slug":"sql-select-distinct-statement","status":"publish","type":"post","link":"https:\/\/kb.hostatom.com\/lesson\/27171\/","title":{"rendered":"SQL\u00a0SELECT DISTINCT\u00a0Statement"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"27171\" class=\"elementor elementor-27171\" data-elementor-post-type=\"post\">\n\t\t\t\t<div class=\"elementor-element elementor-element-4e3e5b9b e-flex e-con-boxed e-con e-parent\" data-id=\"4e3e5b9b\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e197d7d elementor-widget elementor-widget-heading\" data-id=\"e197d7d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0656c1e elementor-widget elementor-widget-text-editor\" data-id=\"0656c1e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>\u0e01\u0e48\u0e2d\u0e19\u0e08\u0e30\u0e40\u0e23\u0e35\u0e22\u0e19\u0e23\u0e39\u0e49\u0e01\u0e32\u0e23\u0e43\u0e0a\u0e49\u0e04\u0e33\u0e2a\u0e31\u0e48\u0e07 <code>DISTINCT<\/code> \u0e21\u0e32\u0e14\u0e39\u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07\u0e15\u0e32\u0e23\u0e32\u0e07\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e17\u0e35\u0e48\u0e08\u0e30\u0e43\u0e0a\u0e49\u0e01\u0e31\u0e19\u0e01\u0e48\u0e2d\u0e19<br \/>\u0e19\u0e35\u0e48\u0e04\u0e37\u0e2d\u0e2a\u0e48\u0e27\u0e19\u0e2b\u0e19\u0e36\u0e48\u0e07\u0e02\u0e2d\u0e07\u0e15\u0e32\u0e23\u0e32\u0e07 <strong>Customers<\/strong> \u0e17\u0e35\u0e48\u0e40\u0e01\u0e47\u0e1a\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e25\u0e39\u0e01\u0e04\u0e49\u0e32\u0e43\u0e19\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f8fab48 elementor-widget elementor-widget-html\" data-id=\"f8fab48\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t\t<div class=\"ls-tbl-wrap\">\r\n<table class=\"ls-tbl\">\r\n<tr>\r\n<th>CustomerID<\/th>\r\n<th>CustomerName<\/th>\r\n<th>ContactName<\/th>\r\n<th>Address<\/th>\r\n<th>City<\/th>\r\n<th>PostalCode<\/th>\r\n<th>Country<\/th>\r\n<\/tr>\r\n<tr>\r\n<td>1<\/td><td>Alfreds Futterkiste<\/td><td>Maria Anders<\/td><td>Obere Str. 57<\/td><td>Berlin<\/td><td>12209<\/td><td>Germany<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>2<\/td><td>Ana Trujillo Emparedados y helados<\/td><td>Ana Trujillo<\/td><td>Avda. de la Constituci\u00f3n 2222<\/td><td>M\u00e9xico D.F.<\/td><td>05021<\/td><td>Mexico<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>3<\/td><td>Antonio Moreno Taquer\u00eda<\/td><td>Antonio Moreno<\/td><td>Mataderos 2312<\/td><td>M\u00e9xico D.F.<\/td><td>05023<\/td><td>Mexico<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>4<\/td><td>Around the Horn<\/td><td>Thomas Hardy<\/td><td>120 Hanover Sq.<\/td><td>London<\/td><td>WA1 1DP<\/td><td>UK<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>5<\/td><td>Berglunds snabbk\u00f6p<\/td><td>Christina Berglund<\/td><td>Berguvsv\u00e4gen 8<\/td><td>Lule\u00e5<\/td><td>S-958 22<\/td><td>Sweden<\/td>\r\n<\/tr>\r\n<\/table>\r\n<\/div>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4ee9a1a elementor-widget elementor-widget-text-editor\" data-id=\"4ee9a1a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><a href=\"https:\/\/kb.hostatom.com\/lesson\/sql\/trysql.php?trystatement=select_all\" target=\"_blank\" rel=\"noopener\">\u0e14\u0e39\u0e15\u0e32\u0e23\u0e32\u0e07 Customers \u0e41\u0e1a\u0e1a\u0e40\u0e15\u0e47\u0e21<\/a><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4894ffb elementor-widget elementor-widget-text-editor\" data-id=\"4894ffb\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>\u0e15\u0e32\u0e23\u0e32\u0e07\u0e19\u0e35\u0e49\u0e21\u0e35 7 \u0e04\u0e2d\u0e25\u0e31\u0e21\u0e19\u0e4c (Columns) \u0e44\u0e14\u0e49\u0e41\u0e01\u0e48 <code>CustomerID<\/code>, <code>CustomerName<\/code>, <code>ContactName<\/code>, <code>Address<\/code>, <code>City<\/code>, <code>PostalCode<\/code>, \u0e41\u0e25\u0e30 <code>Country<\/code><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-78792e2 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"78792e2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e87cbb6 elementor-widget elementor-widget-heading\" data-id=\"e87cbb6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">\u0e40\u0e21\u0e37\u0e48\u0e2d\u0e44\u0e21\u0e48\u0e43\u0e0a\u0e49 DISTINCT ?<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-45917a0 elementor-widget elementor-widget-text-editor\" data-id=\"45917a0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>\u0e2b\u0e32\u0e01\u0e44\u0e21\u0e48\u0e43\u0e0a\u0e49 <code>DISTINCT<\/code> \u0e08\u0e30\u0e14\u0e36\u0e07\u0e04\u0e48\u0e32\u0e02\u0e2d\u0e07\u0e04\u0e2d\u0e25\u0e31\u0e21\u0e19\u0e4c \u201cCountry\u201d \u0e08\u0e32\u0e01\u0e17\u0e38\u0e01\u0e23\u0e30\u0e40\u0e1a\u0e35\u0e22\u0e19 (Records) <br \/>\u0e23\u0e27\u0e21\u0e16\u0e36\u0e07\u0e04\u0e48\u0e32\u0e17\u0e35\u0e48\u0e2d\u0e32\u0e08\u0e0b\u0e49\u0e33\u0e01\u0e31\u0e19\u0e14\u0e49\u0e27\u0e22<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3fd6b6c elementor-widget elementor-widget-code-highlight\" data-id=\"3fd6b6c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-sql line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-sql\">\n\t\t\t\t\t<xmp>SELECT Country \nFROM Customers;<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c6f08ef elementor-widget elementor-widget-button\" data-id=\"c6f08ef\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"https:\/\/kb.hostatom.com\/lesson\/sql\/trysql.php?trystatement=select_no_distinct\" target=\"_blank\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-icon\">\n\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-external-link-alt\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M432,320H400a16,16,0,0,0-16,16V448H64V128H208a16,16,0,0,0,16-16V80a16,16,0,0,0-16-16H48A48,48,0,0,0,0,112V464a48,48,0,0,0,48,48H400a48,48,0,0,0,48-48V336A16,16,0,0,0,432,320ZM488,0h-128c-21.37,0-32.05,25.91-17,41l35.73,35.73L135,320.37a24,24,0,0,0,0,34L157.67,377a24,24,0,0,0,34,0L435.28,133.32,471,169c15,15,41,4.5,41-17V24A24,24,0,0,0,488,0Z\"><\/path><\/svg>\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">\u0e14\u0e39\u0e1c\u0e25\u0e25\u0e31\u0e1e\u0e18\u0e4c<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3f66648 elementor-widget elementor-widget-text-editor\" data-id=\"3f66648\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>\u0e14\u0e31\u0e07\u0e19\u0e31\u0e49\u0e19 <code>DISTINCT<\/code> \u0e08\u0e30\u0e0a\u0e48\u0e27\u0e22\u0e43\u0e2b\u0e49\u0e1c\u0e25\u0e25\u0e31\u0e1e\u0e18\u0e4c\u0e41\u0e2a\u0e14\u0e07\u0e40\u0e09\u0e1e\u0e32\u0e30\u0e04\u0e48\u0e32\u0e17\u0e35\u0e48\u0e41\u0e15\u0e01\u0e15\u0e48\u0e32\u0e07<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dc6b6b6 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"dc6b6b6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-03abc97 elementor-widget elementor-widget-heading\" data-id=\"03abc97\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">\u0e04\u0e33\u0e2a\u0e31\u0e48\u0e07 SELECT DISTINCT<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a1983fa elementor-widget elementor-widget-text-editor\" data-id=\"a1983fa\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>\u0e04\u0e33\u0e2a\u0e31\u0e48\u0e07 <code>SELECT DISTINCT<\/code> \u0e43\u0e0a\u0e49\u0e40\u0e1e\u0e37\u0e48\u0e2d <strong>\u0e41\u0e2a\u0e14\u0e07\u0e40\u0e09\u0e1e\u0e32\u0e30\u0e04\u0e48\u0e32\u0e17\u0e35\u0e48\u0e44\u0e21\u0e48\u0e0b\u0e49\u0e33\u0e01\u0e31\u0e19 (Distinct \/ Different Values)<\/strong> \u0e08\u0e32\u0e01\u0e04\u0e2d\u0e25\u0e31\u0e21\u0e19\u0e4c\u0e43\u0e19\u0e15\u0e32\u0e23\u0e32\u0e07<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7b1a706 elementor-widget elementor-widget-text-editor\" data-id=\"7b1a706\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>\u0e04\u0e33\u0e2a\u0e31\u0e48\u0e07\u0e19\u0e35\u0e49\u0e08\u0e30\u0e01\u0e23\u0e2d\u0e07\u0e04\u0e48\u0e32\u0e17\u0e35\u0e48\u0e0b\u0e49\u0e33\u0e01\u0e31\u0e19\u0e2d\u0e2d\u0e01 \u0e40\u0e0a\u0e48\u0e19 \u201cMexico\u201d \u0e1b\u0e23\u0e32\u0e01\u0e0f\u0e2b\u0e25\u0e32\u0e22\u0e04\u0e23\u0e31\u0e49\u0e07 \u0e41\u0e15\u0e48\u0e1c\u0e25\u0e25\u0e31\u0e1e\u0e18\u0e4c\u0e08\u0e30\u0e21\u0e35\u0e40\u0e1e\u0e35\u0e22\u0e07\u0e04\u0e23\u0e31\u0e49\u0e07\u0e40\u0e14\u0e35\u0e22\u0e27<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-29c595d elementor-widget elementor-widget-code-highlight\" data-id=\"29c595d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-sql line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-sql\">\n\t\t\t\t\t<xmp>SELECT DISTINCT Country\r\nFROM Customers;\r\n<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cef7df3 elementor-widget elementor-widget-button\" data-id=\"cef7df3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"https:\/\/kb.hostatom.com\/lesson\/sql\/trysql.php?trystatement=select_distinct\" target=\"_blank\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-icon\">\n\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-external-link-alt\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M432,320H400a16,16,0,0,0-16,16V448H64V128H208a16,16,0,0,0,16-16V80a16,16,0,0,0-16-16H48A48,48,0,0,0,0,112V464a48,48,0,0,0,48,48H400a48,48,0,0,0,48-48V336A16,16,0,0,0,432,320ZM488,0h-128c-21.37,0-32.05,25.91-17,41l35.73,35.73L135,320.37a24,24,0,0,0,0,34L157.67,377a24,24,0,0,0,34,0L435.28,133.32,471,169c15,15,41,4.5,41-17V24A24,24,0,0,0,488,0Z\"><\/path><\/svg>\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">\u0e14\u0e39\u0e1c\u0e25\u0e25\u0e31\u0e1e\u0e18\u0e4c<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-04aa4cc elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"04aa4cc\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0e48223 elementor-widget elementor-widget-heading\" data-id=\"0e48223\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">\u0e23\u0e39\u0e1b\u0e41\u0e1a\u0e1a\u0e04\u0e33\u0e2a\u0e31\u0e48\u0e07 (Syntax)<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ea96032 elementor-widget elementor-widget-code-highlight\" data-id=\"ea96032\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-sql line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-sql\">\n\t\t\t\t\t<xmp>SELECT DISTINCT column1, column2, ...\r\nFROM table_name;\r\n<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-df241d2 elementor-widget elementor-widget-text-editor\" data-id=\"df241d2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>\u0e04\u0e38\u0e13\u0e2a\u0e32\u0e21\u0e32\u0e23\u0e16\u0e23\u0e30\u0e1a\u0e38\u0e44\u0e14\u0e49\u0e21\u0e32\u0e01\u0e01\u0e27\u0e48\u0e32\u0e2b\u0e19\u0e36\u0e48\u0e07\u0e04\u0e2d\u0e25\u0e31\u0e21\u0e19\u0e4c <br \/>\u0e42\u0e14\u0e22\u0e23\u0e30\u0e1a\u0e1a\u0e08\u0e30\u0e16\u0e37\u0e2d\u0e27\u0e48\u0e32\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25 &#8220;\u0e44\u0e21\u0e48\u0e0b\u0e49\u0e33&#8221; \u0e01\u0e47\u0e15\u0e48\u0e2d\u0e40\u0e21\u0e37\u0e48\u0e2d <strong>\u0e04\u0e48\u0e32\u0e17\u0e31\u0e49\u0e07\u0e2b\u0e21\u0e14\u0e43\u0e19\u0e04\u0e2d\u0e25\u0e31\u0e21\u0e19\u0e4c\u0e17\u0e35\u0e48\u0e23\u0e30\u0e1a\u0e38\u0e41\u0e15\u0e01\u0e15\u0e48\u0e32\u0e07\u0e01\u0e31\u0e19<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e841ef0 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"e841ef0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d27b5ab elementor-widget elementor-widget-heading\" data-id=\"d27b5ab\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">\u0e01\u0e32\u0e23\u0e19\u0e31\u0e1a\u0e04\u0e48\u0e32\u0e17\u0e35\u0e48\u0e44\u0e21\u0e48\u0e0b\u0e49\u0e33\u0e01\u0e31\u0e19 (Count Distinct)<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d68a439 elementor-widget elementor-widget-text-editor\" data-id=\"d68a439\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>\u0e04\u0e38\u0e13\u0e2a\u0e32\u0e21\u0e32\u0e23\u0e16\u0e43\u0e0a\u0e49 <code>DISTINCT<\/code> \u0e23\u0e48\u0e27\u0e21\u0e01\u0e31\u0e1a\u0e1f\u0e31\u0e07\u0e01\u0e4c\u0e0a\u0e31\u0e19 <code>COUNT()<\/code><\/p>\n<p>\u0e40\u0e1e\u0e37\u0e48\u0e2d\u0e2b\u0e32\u0e08\u0e33\u0e19\u0e27\u0e19\u0e04\u0e48\u0e32\u0e17\u0e35\u0e48\u0e41\u0e15\u0e01\u0e15\u0e48\u0e32\u0e07\u0e01\u0e31\u0e19 \u0e40\u0e0a\u0e48\u0e19 \u0e08\u0e33\u0e19\u0e27\u0e19\u0e1b\u0e23\u0e30\u0e40\u0e17\u0e28\u0e17\u0e35\u0e48\u0e44\u0e21\u0e48\u0e0b\u0e49\u0e33\u0e01\u0e31\u0e19\u0e43\u0e19\u0e15\u0e32\u0e23\u0e32\u0e07<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5afcaa3 elementor-widget elementor-widget-code-highlight\" data-id=\"5afcaa3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-sql line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-sql\">\n\t\t\t\t\t<xmp>SELECT COUNT(DISTINCT Country) \nFROM Customers;<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fe488e3 elementor-widget elementor-widget-button\" data-id=\"fe488e3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"https:\/\/kb.hostatom.com\/lesson\/sql\/trysql.php?trystatement=select_distinct2\" target=\"_blank\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-icon\">\n\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-external-link-alt\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M432,320H400a16,16,0,0,0-16,16V448H64V128H208a16,16,0,0,0,16-16V80a16,16,0,0,0-16-16H48A48,48,0,0,0,0,112V464a48,48,0,0,0,48,48H400a48,48,0,0,0,48-48V336A16,16,0,0,0,432,320ZM488,0h-128c-21.37,0-32.05,25.91-17,41l35.73,35.73L135,320.37a24,24,0,0,0,0,34L157.67,377a24,24,0,0,0,34,0L435.28,133.32,471,169c15,15,41,4.5,41-17V24A24,24,0,0,0,488,0Z\"><\/path><\/svg>\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">\u0e14\u0e39\u0e1c\u0e25\u0e25\u0e31\u0e1e\u0e18\u0e4c<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2134efd elementor-alert-warning elementor-widget elementor-widget-alert\" data-id=\"2134efd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"alert.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-alert\" role=\"alert\">\n\n\t\t\t\t\t\t<span class=\"elementor-alert-title\">\u26a0\ufe0f \u0e2b\u0e21\u0e32\u0e22\u0e40\u0e2b\u0e15\u0e38<\/span>\n\t\t\t\n\t\t\t\t\t\t<span class=\"elementor-alert-description\">\u0e04\u0e33\u0e2a\u0e31\u0e48\u0e07 COUNT(DISTINCT column_name) \u0e44\u0e21\u0e48\u0e23\u0e2d\u0e07\u0e23\u0e31\u0e1a\u0e43\u0e19 Microsoft Access<\/span>\n\t\t\t\n\t\t\t\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a9094ab elementor-widget elementor-widget-text-editor\" data-id=\"a9094ab\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>\u0e41\u0e15\u0e48\u0e2a\u0e32\u0e21\u0e32\u0e23\u0e16\u0e43\u0e0a\u0e49\u0e27\u0e34\u0e18\u0e35\u0e41\u0e01\u0e49\u0e44\u0e02 (workaround) \u0e44\u0e14\u0e49\u0e14\u0e31\u0e07\u0e19\u0e35\u0e49:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1d9bd4e elementor-widget elementor-widget-code-highlight\" data-id=\"1d9bd4e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-sql line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-sql\">\n\t\t\t\t\t<xmp>SELECT Count(*) AS DistinctCountries\r\nFROM (SELECT DISTINCT Country FROM Customers);<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07 \u0e01\u0e48\u0e2d\u0e19\u0e08\u0e30\u0e40\u0e23\u0e35\u0e22\u0e19\u0e23\u0e39\u0e49\u0e01\u0e32\u0e23\u0e43\u0e0a\u0e49\u0e04\u0e33\u0e2a\u0e31\u0e48\u0e07 DISTINCT \u0e21\u0e32\u0e14\u0e39\u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07\u0e15\u0e32\u0e23\u0e32\u0e07\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e17\u0e35\u0e48\u0e08\u0e30\u0e43\u0e0a\u0e49\u0e01\u0e31\u0e19\u0e01\u0e48\u0e2d\u0e19\u0e19\u0e35\u0e48\u0e04\u0e37\u0e2d\u0e2a\u0e48\u0e27\u0e19\u0e2b\u0e19\u0e36\u0e48\u0e07\u0e02\u0e2d\u0e07\u0e15\u0e32\u0e23\u0e32\u0e07 Customers \u0e17\u0e35\u0e48\u0e40\u0e01\u0e47\u0e1a\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e25\u0e39\u0e01\u0e04\u0e49\u0e32\u0e43\u0e19\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25 CustomerID CustomerName ContactName Address City PostalCode Country 1 Alfreds Futterkiste Maria Anders Obere Str. 57 Berlin 12209 Germany 2 Ana Trujillo Emparedados y helados Ana Trujillo Avda. de la Constituci\u00f3n 2222 M\u00e9xico D.F. 05021 Mexico 3 Antonio Moreno Taquer\u00eda Antonio Moreno Mataderos 2312 M\u00e9xico D.F. 05023 Mexico 4 Around [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-27171","post","type-post","status-publish","format-standard","hentry","category-sql"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO Pro 5.0.4 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07 \u0e01\u0e48\u0e2d\u0e19\u0e08\u0e30\u0e40\u0e23\u0e35\u0e22\u0e19\u0e23\u0e39\u0e49\u0e01\u0e32\u0e23\u0e43\u0e0a\u0e49\u0e04\u0e33\u0e2a\u0e31\u0e48\u0e07 DISTINCT \u0e21\u0e32\u0e14\u0e39\u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07\u0e15\u0e32\u0e23\u0e32\u0e07\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e17\u0e35\u0e48\u0e08\u0e30\u0e43\u0e0a\u0e49\u0e01\u0e31\u0e19\u0e01\u0e48\u0e2d\u0e19\u0e19\u0e35\u0e48\u0e04\u0e37\u0e2d\u0e2a\u0e48\u0e27\u0e19\u0e2b\u0e19\u0e36\u0e48\u0e07\u0e02\u0e2d\u0e07\u0e15\u0e32\u0e23\u0e32\u0e07 Customers \u0e17\u0e35\u0e48\u0e40\u0e01\u0e47\u0e1a\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e25\u0e39\u0e01\u0e04\u0e49\u0e32\u0e43\u0e19\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25 CustomerID CustomerName ContactName Address City PostalCode Country 1Alfreds FutterkisteMaria AndersObere Str. 57Berlin12209Germany 2Ana Trujillo Emparedados y heladosAna TrujilloAvda. de la Constituci\u00f3n 2222M\u00e9xico D.F.05021Mexico 3Antonio Moreno Taquer\u00edaAntonio MorenoMataderos 2312M\u00e9xico D.F.05023Mexico 4Around the HornThomas Hardy120 Hanover Sq.LondonWA1 1DPUK 5Berglunds snabbk\u00f6pChristina BerglundBerguvsv\u00e4gen 8Lule\u00e5S-958 22Sweden \u0e14\u0e39\u0e15\u0e32\u0e23\u0e32\u0e07 Customers \u0e41\u0e1a\u0e1a\u0e40\u0e15\u0e47\u0e21 \u0e15\u0e32\u0e23\u0e32\u0e07\u0e19\u0e35\u0e49\u0e21\u0e35 7 \u0e04\u0e2d\u0e25\u0e31\u0e21\u0e19\u0e4c (Columns) \u0e44\u0e14\u0e49\u0e41\u0e01\u0e48\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"atom\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/kb.hostatom.com\/lesson\/27171\/\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO Pro (AIOSEO) 5.0.4\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"SQL SELECT DISTINCT Statement - \u0e1a\u0e17\u0e40\u0e23\u0e35\u0e22\u0e19 | hostatom\" \/>\n\t\t<meta name=\"twitter:description\" content=\"\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07 \u0e01\u0e48\u0e2d\u0e19\u0e08\u0e30\u0e40\u0e23\u0e35\u0e22\u0e19\u0e23\u0e39\u0e49\u0e01\u0e32\u0e23\u0e43\u0e0a\u0e49\u0e04\u0e33\u0e2a\u0e31\u0e48\u0e07 DISTINCT \u0e21\u0e32\u0e14\u0e39\u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07\u0e15\u0e32\u0e23\u0e32\u0e07\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e17\u0e35\u0e48\u0e08\u0e30\u0e43\u0e0a\u0e49\u0e01\u0e31\u0e19\u0e01\u0e48\u0e2d\u0e19\u0e19\u0e35\u0e48\u0e04\u0e37\u0e2d\u0e2a\u0e48\u0e27\u0e19\u0e2b\u0e19\u0e36\u0e48\u0e07\u0e02\u0e2d\u0e07\u0e15\u0e32\u0e23\u0e32\u0e07 Customers \u0e17\u0e35\u0e48\u0e40\u0e01\u0e47\u0e1a\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e25\u0e39\u0e01\u0e04\u0e49\u0e32\u0e43\u0e19\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25 CustomerID CustomerName ContactName Address City PostalCode Country 1Alfreds FutterkisteMaria AndersObere Str. 57Berlin12209Germany 2Ana Trujillo Emparedados y heladosAna TrujilloAvda. de la Constituci\u00f3n 2222M\u00e9xico D.F.05021Mexico 3Antonio Moreno Taquer\u00edaAntonio MorenoMataderos 2312M\u00e9xico D.F.05023Mexico 4Around the HornThomas Hardy120 Hanover Sq.LondonWA1 1DPUK 5Berglunds snabbk\u00f6pChristina BerglundBerguvsv\u00e4gen 8Lule\u00e5S-958 22Sweden \u0e14\u0e39\u0e15\u0e32\u0e23\u0e32\u0e07 Customers \u0e41\u0e1a\u0e1a\u0e40\u0e15\u0e47\u0e21 \u0e15\u0e32\u0e23\u0e32\u0e07\u0e19\u0e35\u0e49\u0e21\u0e35 7 \u0e04\u0e2d\u0e25\u0e31\u0e21\u0e19\u0e4c (Columns) \u0e44\u0e14\u0e49\u0e41\u0e01\u0e48\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/kb.hostatom.com\/lesson\/wp-content\/uploads\/2025\/09\/hostatom-w-logo.webp\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/kb.hostatom.com\\\/lesson\\\/27171\\\/#blogposting\",\"name\":\"SQL SELECT DISTINCT Statement - \\u0e1a\\u0e17\\u0e40\\u0e23\\u0e35\\u0e22\\u0e19 | hostatom\",\"headline\":\"SQL\\u00a0SELECT DISTINCT\\u00a0Statement\",\"author\":{\"@id\":\"https:\\\/\\\/kb.hostatom.com\\\/lesson\\\/author\\\/atom\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/kb.hostatom.com\\\/lesson\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/kb.hostatom.com\\\/lesson\\\/wp-content\\\/uploads\\\/2025\\\/09\\\/hostatom-w-logo.webp\",\"@id\":\"https:\\\/\\\/kb.hostatom.com\\\/lesson\\\/#articleImage\",\"width\":319,\"height\":69},\"datePublished\":\"2022-12-01T11:00:36+00:00\",\"dateModified\":\"2025-11-11T01:37:24+00:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kb.hostatom.com\\\/lesson\\\/27171\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/kb.hostatom.com\\\/lesson\\\/27171\\\/#webpage\"},\"articleSection\":\"SQL\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kb.hostatom.com\\\/lesson\\\/27171\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kb.hostatom.com\\\/lesson\\\/#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kb.hostatom.com\\\/lesson\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kb.hostatom.com\\\/lesson\\\/category\\\/sql\\\/#listItem\",\"name\":\"SQL\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kb.hostatom.com\\\/lesson\\\/category\\\/sql\\\/#listItem\",\"position\":2,\"name\":\"SQL\",\"item\":\"https:\\\/\\\/kb.hostatom.com\\\/lesson\\\/category\\\/sql\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kb.hostatom.com\\\/lesson\\\/27171\\\/#listItem\",\"name\":\"SQL\\u00a0SELECT DISTINCT\\u00a0Statement\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kb.hostatom.com\\\/lesson\\\/#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kb.hostatom.com\\\/lesson\\\/27171\\\/#listItem\",\"position\":3,\"name\":\"SQL\\u00a0SELECT DISTINCT\\u00a0Statement\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kb.hostatom.com\\\/lesson\\\/category\\\/sql\\\/#listItem\",\"name\":\"SQL\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/kb.hostatom.com\\\/lesson\\\/#organization\",\"name\":\"\\u0e1a\\u0e17\\u0e40\\u0e23\\u0e35\\u0e22\\u0e19 | hostatom\",\"url\":\"https:\\\/\\\/kb.hostatom.com\\\/lesson\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/kb.hostatom.com\\\/lesson\\\/wp-content\\\/uploads\\\/2025\\\/09\\\/hostatom-w-logo.webp\",\"@id\":\"https:\\\/\\\/kb.hostatom.com\\\/lesson\\\/27171\\\/#organizationLogo\",\"width\":319,\"height\":69},\"image\":{\"@id\":\"https:\\\/\\\/kb.hostatom.com\\\/lesson\\\/27171\\\/#organizationLogo\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/kb.hostatom.com\\\/lesson\\\/author\\\/atom\\\/#author\",\"url\":\"https:\\\/\\\/kb.hostatom.com\\\/lesson\\\/author\\\/atom\\\/\",\"name\":\"atom\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/kb.hostatom.com\\\/lesson\\\/27171\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1398e885f2c093231db5c45d2e6565274f768e57b8404e4a7585bb8714b69ec3?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"atom\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kb.hostatom.com\\\/lesson\\\/27171\\\/#webpage\",\"url\":\"https:\\\/\\\/kb.hostatom.com\\\/lesson\\\/27171\\\/\",\"name\":\"SQL SELECT DISTINCT Statement - \\u0e1a\\u0e17\\u0e40\\u0e23\\u0e35\\u0e22\\u0e19 | hostatom\",\"description\":\"\\u0e10\\u0e32\\u0e19\\u0e02\\u0e49\\u0e2d\\u0e21\\u0e39\\u0e25\\u0e15\\u0e31\\u0e27\\u0e2d\\u0e22\\u0e48\\u0e32\\u0e07 \\u0e01\\u0e48\\u0e2d\\u0e19\\u0e08\\u0e30\\u0e40\\u0e23\\u0e35\\u0e22\\u0e19\\u0e23\\u0e39\\u0e49\\u0e01\\u0e32\\u0e23\\u0e43\\u0e0a\\u0e49\\u0e04\\u0e33\\u0e2a\\u0e31\\u0e48\\u0e07 DISTINCT \\u0e21\\u0e32\\u0e14\\u0e39\\u0e15\\u0e31\\u0e27\\u0e2d\\u0e22\\u0e48\\u0e32\\u0e07\\u0e15\\u0e32\\u0e23\\u0e32\\u0e07\\u0e02\\u0e49\\u0e2d\\u0e21\\u0e39\\u0e25\\u0e17\\u0e35\\u0e48\\u0e08\\u0e30\\u0e43\\u0e0a\\u0e49\\u0e01\\u0e31\\u0e19\\u0e01\\u0e48\\u0e2d\\u0e19\\u0e19\\u0e35\\u0e48\\u0e04\\u0e37\\u0e2d\\u0e2a\\u0e48\\u0e27\\u0e19\\u0e2b\\u0e19\\u0e36\\u0e48\\u0e07\\u0e02\\u0e2d\\u0e07\\u0e15\\u0e32\\u0e23\\u0e32\\u0e07 Customers \\u0e17\\u0e35\\u0e48\\u0e40\\u0e01\\u0e47\\u0e1a\\u0e02\\u0e49\\u0e2d\\u0e21\\u0e39\\u0e25\\u0e25\\u0e39\\u0e01\\u0e04\\u0e49\\u0e32\\u0e43\\u0e19\\u0e10\\u0e32\\u0e19\\u0e02\\u0e49\\u0e2d\\u0e21\\u0e39\\u0e25 CustomerID CustomerName ContactName Address City PostalCode Country 1Alfreds FutterkisteMaria AndersObere Str. 57Berlin12209Germany 2Ana Trujillo Emparedados y heladosAna TrujilloAvda. de la Constituci\\u00f3n 2222M\\u00e9xico D.F.05021Mexico 3Antonio Moreno Taquer\\u00edaAntonio MorenoMataderos 2312M\\u00e9xico D.F.05023Mexico 4Around the HornThomas Hardy120 Hanover Sq.LondonWA1 1DPUK 5Berglunds snabbk\\u00f6pChristina BerglundBerguvsv\\u00e4gen 8Lule\\u00e5S-958 22Sweden \\u0e14\\u0e39\\u0e15\\u0e32\\u0e23\\u0e32\\u0e07 Customers \\u0e41\\u0e1a\\u0e1a\\u0e40\\u0e15\\u0e47\\u0e21 \\u0e15\\u0e32\\u0e23\\u0e32\\u0e07\\u0e19\\u0e35\\u0e49\\u0e21\\u0e35 7 \\u0e04\\u0e2d\\u0e25\\u0e31\\u0e21\\u0e19\\u0e4c (Columns) \\u0e44\\u0e14\\u0e49\\u0e41\\u0e01\\u0e48\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kb.hostatom.com\\\/lesson\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kb.hostatom.com\\\/lesson\\\/27171\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/kb.hostatom.com\\\/lesson\\\/author\\\/atom\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/kb.hostatom.com\\\/lesson\\\/author\\\/atom\\\/#author\"},\"datePublished\":\"2022-12-01T11:00:36+00:00\",\"dateModified\":\"2025-11-11T01:37:24+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kb.hostatom.com\\\/lesson\\\/#website\",\"url\":\"https:\\\/\\\/kb.hostatom.com\\\/lesson\\\/\",\"name\":\"\\u0e1a\\u0e17\\u0e40\\u0e23\\u0e35\\u0e22\\u0e19 | hostatom\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/kb.hostatom.com\\\/lesson\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO Pro -->\r\n\t\t<title>SQL SELECT DISTINCT Statement - \u0e1a\u0e17\u0e40\u0e23\u0e35\u0e22\u0e19 | hostatom<\/title>\n\n","aioseo_head_json":{"title":"SQL SELECT DISTINCT Statement - \u0e1a\u0e17\u0e40\u0e23\u0e35\u0e22\u0e19 | hostatom","description":"\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07 \u0e01\u0e48\u0e2d\u0e19\u0e08\u0e30\u0e40\u0e23\u0e35\u0e22\u0e19\u0e23\u0e39\u0e49\u0e01\u0e32\u0e23\u0e43\u0e0a\u0e49\u0e04\u0e33\u0e2a\u0e31\u0e48\u0e07 DISTINCT \u0e21\u0e32\u0e14\u0e39\u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07\u0e15\u0e32\u0e23\u0e32\u0e07\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e17\u0e35\u0e48\u0e08\u0e30\u0e43\u0e0a\u0e49\u0e01\u0e31\u0e19\u0e01\u0e48\u0e2d\u0e19\u0e19\u0e35\u0e48\u0e04\u0e37\u0e2d\u0e2a\u0e48\u0e27\u0e19\u0e2b\u0e19\u0e36\u0e48\u0e07\u0e02\u0e2d\u0e07\u0e15\u0e32\u0e23\u0e32\u0e07 Customers \u0e17\u0e35\u0e48\u0e40\u0e01\u0e47\u0e1a\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e25\u0e39\u0e01\u0e04\u0e49\u0e32\u0e43\u0e19\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25 CustomerID CustomerName ContactName Address City PostalCode Country 1Alfreds FutterkisteMaria AndersObere Str. 57Berlin12209Germany 2Ana Trujillo Emparedados y heladosAna TrujilloAvda. de la Constituci\u00f3n 2222M\u00e9xico D.F.05021Mexico 3Antonio Moreno Taquer\u00edaAntonio MorenoMataderos 2312M\u00e9xico D.F.05023Mexico 4Around the HornThomas Hardy120 Hanover Sq.LondonWA1 1DPUK 5Berglunds snabbk\u00f6pChristina BerglundBerguvsv\u00e4gen 8Lule\u00e5S-958 22Sweden \u0e14\u0e39\u0e15\u0e32\u0e23\u0e32\u0e07 Customers \u0e41\u0e1a\u0e1a\u0e40\u0e15\u0e47\u0e21 \u0e15\u0e32\u0e23\u0e32\u0e07\u0e19\u0e35\u0e49\u0e21\u0e35 7 \u0e04\u0e2d\u0e25\u0e31\u0e21\u0e19\u0e4c (Columns) \u0e44\u0e14\u0e49\u0e41\u0e01\u0e48","canonical_url":"https:\/\/kb.hostatom.com\/lesson\/27171\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/kb.hostatom.com\/lesson\/27171\/#blogposting","name":"SQL SELECT DISTINCT Statement - \u0e1a\u0e17\u0e40\u0e23\u0e35\u0e22\u0e19 | hostatom","headline":"SQL\u00a0SELECT DISTINCT\u00a0Statement","author":{"@id":"https:\/\/kb.hostatom.com\/lesson\/author\/atom\/#author"},"publisher":{"@id":"https:\/\/kb.hostatom.com\/lesson\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/kb.hostatom.com\/lesson\/wp-content\/uploads\/2025\/09\/hostatom-w-logo.webp","@id":"https:\/\/kb.hostatom.com\/lesson\/#articleImage","width":319,"height":69},"datePublished":"2022-12-01T11:00:36+00:00","dateModified":"2025-11-11T01:37:24+00:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/kb.hostatom.com\/lesson\/27171\/#webpage"},"isPartOf":{"@id":"https:\/\/kb.hostatom.com\/lesson\/27171\/#webpage"},"articleSection":"SQL"},{"@type":"BreadcrumbList","@id":"https:\/\/kb.hostatom.com\/lesson\/27171\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/kb.hostatom.com\/lesson\/#listItem","position":1,"name":"Home","item":"https:\/\/kb.hostatom.com\/lesson\/","nextItem":{"@type":"ListItem","@id":"https:\/\/kb.hostatom.com\/lesson\/category\/sql\/#listItem","name":"SQL"}},{"@type":"ListItem","@id":"https:\/\/kb.hostatom.com\/lesson\/category\/sql\/#listItem","position":2,"name":"SQL","item":"https:\/\/kb.hostatom.com\/lesson\/category\/sql\/","nextItem":{"@type":"ListItem","@id":"https:\/\/kb.hostatom.com\/lesson\/27171\/#listItem","name":"SQL\u00a0SELECT DISTINCT\u00a0Statement"},"previousItem":{"@type":"ListItem","@id":"https:\/\/kb.hostatom.com\/lesson\/#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/kb.hostatom.com\/lesson\/27171\/#listItem","position":3,"name":"SQL\u00a0SELECT DISTINCT\u00a0Statement","previousItem":{"@type":"ListItem","@id":"https:\/\/kb.hostatom.com\/lesson\/category\/sql\/#listItem","name":"SQL"}}]},{"@type":"Organization","@id":"https:\/\/kb.hostatom.com\/lesson\/#organization","name":"\u0e1a\u0e17\u0e40\u0e23\u0e35\u0e22\u0e19 | hostatom","url":"https:\/\/kb.hostatom.com\/lesson\/","logo":{"@type":"ImageObject","url":"https:\/\/kb.hostatom.com\/lesson\/wp-content\/uploads\/2025\/09\/hostatom-w-logo.webp","@id":"https:\/\/kb.hostatom.com\/lesson\/27171\/#organizationLogo","width":319,"height":69},"image":{"@id":"https:\/\/kb.hostatom.com\/lesson\/27171\/#organizationLogo"}},{"@type":"Person","@id":"https:\/\/kb.hostatom.com\/lesson\/author\/atom\/#author","url":"https:\/\/kb.hostatom.com\/lesson\/author\/atom\/","name":"atom","image":{"@type":"ImageObject","@id":"https:\/\/kb.hostatom.com\/lesson\/27171\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/1398e885f2c093231db5c45d2e6565274f768e57b8404e4a7585bb8714b69ec3?s=96&d=mm&r=g","width":96,"height":96,"caption":"atom"}},{"@type":"WebPage","@id":"https:\/\/kb.hostatom.com\/lesson\/27171\/#webpage","url":"https:\/\/kb.hostatom.com\/lesson\/27171\/","name":"SQL SELECT DISTINCT Statement - \u0e1a\u0e17\u0e40\u0e23\u0e35\u0e22\u0e19 | hostatom","description":"\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07 \u0e01\u0e48\u0e2d\u0e19\u0e08\u0e30\u0e40\u0e23\u0e35\u0e22\u0e19\u0e23\u0e39\u0e49\u0e01\u0e32\u0e23\u0e43\u0e0a\u0e49\u0e04\u0e33\u0e2a\u0e31\u0e48\u0e07 DISTINCT \u0e21\u0e32\u0e14\u0e39\u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07\u0e15\u0e32\u0e23\u0e32\u0e07\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e17\u0e35\u0e48\u0e08\u0e30\u0e43\u0e0a\u0e49\u0e01\u0e31\u0e19\u0e01\u0e48\u0e2d\u0e19\u0e19\u0e35\u0e48\u0e04\u0e37\u0e2d\u0e2a\u0e48\u0e27\u0e19\u0e2b\u0e19\u0e36\u0e48\u0e07\u0e02\u0e2d\u0e07\u0e15\u0e32\u0e23\u0e32\u0e07 Customers \u0e17\u0e35\u0e48\u0e40\u0e01\u0e47\u0e1a\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e25\u0e39\u0e01\u0e04\u0e49\u0e32\u0e43\u0e19\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25 CustomerID CustomerName ContactName Address City PostalCode Country 1Alfreds FutterkisteMaria AndersObere Str. 57Berlin12209Germany 2Ana Trujillo Emparedados y heladosAna TrujilloAvda. de la Constituci\u00f3n 2222M\u00e9xico D.F.05021Mexico 3Antonio Moreno Taquer\u00edaAntonio MorenoMataderos 2312M\u00e9xico D.F.05023Mexico 4Around the HornThomas Hardy120 Hanover Sq.LondonWA1 1DPUK 5Berglunds snabbk\u00f6pChristina BerglundBerguvsv\u00e4gen 8Lule\u00e5S-958 22Sweden \u0e14\u0e39\u0e15\u0e32\u0e23\u0e32\u0e07 Customers \u0e41\u0e1a\u0e1a\u0e40\u0e15\u0e47\u0e21 \u0e15\u0e32\u0e23\u0e32\u0e07\u0e19\u0e35\u0e49\u0e21\u0e35 7 \u0e04\u0e2d\u0e25\u0e31\u0e21\u0e19\u0e4c (Columns) \u0e44\u0e14\u0e49\u0e41\u0e01\u0e48","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/kb.hostatom.com\/lesson\/#website"},"breadcrumb":{"@id":"https:\/\/kb.hostatom.com\/lesson\/27171\/#breadcrumblist"},"author":{"@id":"https:\/\/kb.hostatom.com\/lesson\/author\/atom\/#author"},"creator":{"@id":"https:\/\/kb.hostatom.com\/lesson\/author\/atom\/#author"},"datePublished":"2022-12-01T11:00:36+00:00","dateModified":"2025-11-11T01:37:24+00:00"},{"@type":"WebSite","@id":"https:\/\/kb.hostatom.com\/lesson\/#website","url":"https:\/\/kb.hostatom.com\/lesson\/","name":"\u0e1a\u0e17\u0e40\u0e23\u0e35\u0e22\u0e19 | hostatom","inLanguage":"en-US","publisher":{"@id":"https:\/\/kb.hostatom.com\/lesson\/#organization"}}]},"twitter:card":"summary_large_image","twitter:title":"SQL SELECT DISTINCT Statement - \u0e1a\u0e17\u0e40\u0e23\u0e35\u0e22\u0e19 | hostatom","twitter:description":"\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07 \u0e01\u0e48\u0e2d\u0e19\u0e08\u0e30\u0e40\u0e23\u0e35\u0e22\u0e19\u0e23\u0e39\u0e49\u0e01\u0e32\u0e23\u0e43\u0e0a\u0e49\u0e04\u0e33\u0e2a\u0e31\u0e48\u0e07 DISTINCT \u0e21\u0e32\u0e14\u0e39\u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07\u0e15\u0e32\u0e23\u0e32\u0e07\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e17\u0e35\u0e48\u0e08\u0e30\u0e43\u0e0a\u0e49\u0e01\u0e31\u0e19\u0e01\u0e48\u0e2d\u0e19\u0e19\u0e35\u0e48\u0e04\u0e37\u0e2d\u0e2a\u0e48\u0e27\u0e19\u0e2b\u0e19\u0e36\u0e48\u0e07\u0e02\u0e2d\u0e07\u0e15\u0e32\u0e23\u0e32\u0e07 Customers \u0e17\u0e35\u0e48\u0e40\u0e01\u0e47\u0e1a\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e25\u0e39\u0e01\u0e04\u0e49\u0e32\u0e43\u0e19\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25 CustomerID CustomerName ContactName Address City PostalCode Country 1Alfreds FutterkisteMaria AndersObere Str. 57Berlin12209Germany 2Ana Trujillo Emparedados y heladosAna TrujilloAvda. de la Constituci\u00f3n 2222M\u00e9xico D.F.05021Mexico 3Antonio Moreno Taquer\u00edaAntonio MorenoMataderos 2312M\u00e9xico D.F.05023Mexico 4Around the HornThomas Hardy120 Hanover Sq.LondonWA1 1DPUK 5Berglunds snabbk\u00f6pChristina BerglundBerguvsv\u00e4gen 8Lule\u00e5S-958 22Sweden \u0e14\u0e39\u0e15\u0e32\u0e23\u0e32\u0e07 Customers \u0e41\u0e1a\u0e1a\u0e40\u0e15\u0e47\u0e21 \u0e15\u0e32\u0e23\u0e32\u0e07\u0e19\u0e35\u0e49\u0e21\u0e35 7 \u0e04\u0e2d\u0e25\u0e31\u0e21\u0e19\u0e4c (Columns) \u0e44\u0e14\u0e49\u0e41\u0e01\u0e48","twitter:image":"https:\/\/kb.hostatom.com\/lesson\/wp-content\/uploads\/2025\/09\/hostatom-w-logo.webp"},"aioseo_meta_data":{"post_id":"27171","title":null,"description":null,"keywords":null,"keyphrases":{"focus":[],"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":"2026-08-18 04:52:28","breadcrumb_settings":null,"limit_modified_date":false,"open_ai":null,"ai":null,"created":"2026-02-19 04:41:24","updated":"2026-10-29 06:21:25","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t<a href=\"https:\/\/kb.hostatom.com\/lesson\/\" title=\"Home\">Home<\/a>\n<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t<a href=\"https:\/\/kb.hostatom.com\/lesson\/category\/sql\/\" title=\"SQL\">SQL<\/a>\n<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\tSQL SELECT DISTINCT Statement\n<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/kb.hostatom.com\/lesson\/"},{"label":"SQL","link":"https:\/\/kb.hostatom.com\/lesson\/category\/sql\/"},{"label":"SQL\u00a0SELECT DISTINCT\u00a0Statement","link":"https:\/\/kb.hostatom.com\/lesson\/27171\/"}],"_links":{"self":[{"href":"https:\/\/kb.hostatom.com\/lesson\/wp-json\/wp\/v2\/posts\/27171","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kb.hostatom.com\/lesson\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kb.hostatom.com\/lesson\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kb.hostatom.com\/lesson\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.hostatom.com\/lesson\/wp-json\/wp\/v2\/comments?post=27171"}],"version-history":[{"count":0,"href":"https:\/\/kb.hostatom.com\/lesson\/wp-json\/wp\/v2\/posts\/27171\/revisions"}],"wp:attachment":[{"href":"https:\/\/kb.hostatom.com\/lesson\/wp-json\/wp\/v2\/media?parent=27171"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.hostatom.com\/lesson\/wp-json\/wp\/v2\/categories?post=27171"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.hostatom.com\/lesson\/wp-json\/wp\/v2\/tags?post=27171"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}