{"id":125,"date":"2024-08-21T04:50:24","date_gmt":"2024-08-21T04:50:24","guid":{"rendered":"https:\/\/techkubo.com\/sql\/?p=125"},"modified":"2025-05-09T08:49:52","modified_gmt":"2025-05-09T08:49:52","slug":"sql-select-distinct","status":"publish","type":"post","link":"https:\/\/techkubo.com\/sql\/sql-select-distinct\/","title":{"rendered":"SQL Select Distinct"},"content":{"rendered":"\n

The SELECT DISTINCT statement in SQL is used to retrieve unique values from a column or set of columns in a table. It helps to eliminate duplicate rows from the result set, ensuring that only distinct values are displayed.<\/p>\n\n\n\n


<\/p>\n\n\n\n

SQL Select Distinct Syntax<\/h2>\n\n\n\n
SELECT DISTINCT column1, column2, ...\nFROM table_name;<\/pre><\/div>\n\n\n\n

<\/p>\n\n\n\n
SQL Select Distinct Examples<\/h2>\n\n\n\n
SQL Select Distinct Selecting Unique Values from a Single Column Example<\/h3>\n\n\n\n
This query retrieves a list of distinct specialty values from the doctors table. If multiple doctors have the same specialty, it will only show that specialty once.<\/p>\n\n\n\n
SELECT DISTINCT specialty\nFROM Doctors;<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\n
Try It Out!<\/a><\/div>\n<\/div>\n\n\n\n

<\/p>\n\n\n\n
SQL Select Distinct Selecting Unique Combinations from Multiple Columns<\/h2>\n\n\n\n
This query retrieves unique pairs of first_name and last_name.<\/p>\n\n\n\n
SELECT DISTINCT first_name, last_name\nFROM Doctors;<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n
SQL Select Distinct Visual Diagram<\/h2>\n\n\n\n
\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n
SQL Select Distinct Labs<\/h2>\n\n\n\n