5.7
Using the DISTINCT Statement
Removing Duplicate Values With DISTINCT
- The DISTINCT keyword allows you to eliminate duplicate rows in aggregate functions.
- You may also use the DISTINCT keyword with columns of the base table in a SELECT statement.
- COUNT(list_price) counts all the rows in the product table that have a list price.
- COUNT(DISTINCT list_price) eliminates duplicate values in the list_price.
Code Sample:
Example
USE bike;
SELECT COUNT(list_price), COUNT(DISTINCT list_price)
FROM product;
Output:
End-of-Chapter Survey
: How would you rate the overall quality of this chapter?- Very Low Quality
- Low Quality
- Moderate Quality
- High Quality
- Very High Quality