The SQL DISTINCT statement is essential for filtering out duplicate rows in your queries, making it a vital tool for extracting unique data points. This guide provides a concise overview of using DISTINCT with practical examples to improve your data analysis skills.
Retrieve unique cities using DISTINCT
In a database, you may want to find unique values in a column to better understand your data. For instance, listing all the unique cities in your orders table can be achieved using the query below:
SELECT DISTINCT city
FROM orders;Unique combinations across columns
Sometimes, you need more than just unique values from one column — you might want combinations across multiple columns. For example, you can find the unique combinations of customer names, their cities, and the products they ordered.
SELECT DISTINCT customername, city, product
FROM orders;Aggregating with DISTINCT
You can also use DISTINCT with aggregate functions to calculate values over unique entries. For instance, counting the number of unique customers in each city can help analyze market trends.
SELECT city, COUNT(DISTINCT customername) AS UniqueCustomersCount
FROM orders
GROUP BY city;Using WHERE with DISTINCT
By combining DISTINCT with a WHERE clause, you can filter unique values based on specific conditions. For example, you can find unique customer details from New York.
SELECT DISTINCT customername, address, phone
FROM orders
WHERE city = 'New York';FAQ
What is DISTINCT in SQL?
DISTINCT filters out duplicate rows in query results, displaying only unique values.
How is DISTINCT used?
Place it after SELECT in a query, followed by columns where duplicates should be removed.
What’s the difference between UNIQUE and DISTINCT?
UNIQUE ensures values occur only once, while DISTINCT eliminates duplicates in the output.
Can DISTINCT work with other SQL clauses?
Yes, it can be combined with clauses like WHERE, GROUP BY, and ORDER BY.
Conclusion
SQL DISTINCT simplifies data extraction by eliminating duplicate rows, enhancing the clarity and utility of query results. By leveraging this tool, you can refine your data and gain more meaningful insights. For a deeper understanding and detailed examples, check out the full guide SQL DISTINCT: A Comprehensive Guide.
Get DbVisualizer’s stories in your inbox
Join Medium for free to get updates from this writer.
Remember, mastering SQL basics like DISTINCT sets a strong foundation for more advanced database operations.
