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:

USE bike;
SELECT COUNT(list_price), COUNT(DISTINCT list_price) 
FROM product;



This content is provided to you freely by EdTech Books.

Access it online or download it at https://edtechbooks.org/learning_mysql/using_the_distinct_s.