Select Unique SQL

Galaxy Glossary

How do you retrieve only unique rows from a table in SQL?

The `DISTINCT` keyword in SQL is used to eliminate duplicate rows from a result set, returning only unique values for a specified column or set of columns. This is crucial for data analysis and reporting, ensuring accurate counts and summaries.

Sign up for the latest in SQL knowledge from the Galaxy Team!
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Description

In SQL, retrieving unique data is a common task. Imagine you have a table of customer orders, and you want to see a list of all the unique products ordered. Using the `DISTINCT` keyword, you can easily achieve this. The `DISTINCT` keyword filters out duplicate rows, ensuring that each row in the result set is unique. This is particularly useful when you need to identify distinct categories, values, or combinations of values within your data. For example, you might want to find the unique cities where your customers reside or the unique product types sold. The `DISTINCT` keyword is a fundamental tool for data analysis and reporting, ensuring that your results are accurate and reliable. It's important to note that `DISTINCT` operates on the entire row, not just a single column. If you want to select unique values from a specific column, you specify that column in the `SELECT` statement. This ensures that only the unique values from that column are returned.

Why Select Unique SQL is important

The `DISTINCT` keyword is essential for accurate data analysis and reporting. It ensures that results are not skewed by duplicate entries, providing a clear picture of the unique values present in your data. This is crucial for tasks like calculating unique customer counts, identifying distinct product types, or generating accurate summaries.

Select Unique SQL Example Usage


-- Find all customers whose names start with 'A'.
SELECT customer_name
FROM Customers
WHERE customer_name LIKE 'A%';

-- Find all products containing the word 'Laptop'.
SELECT product_name
FROM Products
WHERE product_name LIKE '%Laptop%';

-- Find all customers whose names have exactly 5 characters.
SELECT customer_name
FROM Customers
WHERE customer_name LIKE '_____';

-- Find all products whose names contain a space.
SELECT product_name
FROM Products
WHERE product_name LIKE '% %';

-- Find all products whose names start with 'T' and have exactly 7 characters.
SELECT product_name
FROM Products
WHERE product_name LIKE 'T_____';

Common Mistakes

Want to learn about other SQL terms?

With Cte In SQL

Common Table Expressions (CTEs) are temporary, named result sets defined within a single SQL statement. They enhance query readability and reusability by breaking down complex queries into smaller, manageable parts.

Where Vs Having SQL

WHERE and HAVING are both used for filtering data in SQL, but they operate on different levels. WHERE filters rows before any aggregation, while HAVING filters groups after aggregation.

Windows Functions In SQL

Window functions in SQL perform calculations over a set of rows related to the current row, unlike aggregate functions which summarize data across all rows. They are powerful tools for analyzing data within a specific context.

Company
BlogFeaturesPricingAboutCareersFeature Requests
Resources
DocsSupportSecurityBrand Kit
Explore
Product TourData Job BoardRecruitersConsultantsStartup ToolsMemes
Learn
Learn SQLBeginner ResourcesData ToolsSQL Interview PrepCommon ErrorsSQL OptimizationSQL In Other LanguagesGlossary
Comparisons
DatagripTablePlusDBeaverBeekeeper StudiopgAdminPosticoCursor
HexBrieferPopSQLSherloqBlazeSQLSweep AIWaii AIOuterbase
© 2025 Galaxy Software Inc.
hello@getgalaxy.io
Reddit IconProduct Hunt IconTwitter / X IconLinkedIn Icon