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:

ag_07.png

This content is provided to you freely by BYU-I Books.

Access it online or download it at https://books.byui.edu/learning_mysql/using_the_distinct_s.