Eliminating Duplicates

• ALL

  • the default
  • returns all qualified rows

• DISTINCT

  • returns only unique
  • when more than 1 item in SELECT list, returns only the unique combinations.

• Both can only occur once and only at the beginning of the SELCT list.

SELECT DISTINCT book_store

FROM stores

Previous slide

Next slide

Back to first slide

View graphic version