Eliminating Duplicates with DISTINCT
The DISTINCT keyword eliminates duplicate rows from the results of a SELECT statement.
If DISTINCT is not specified, all rows are returned,including duplicates.
ex. Result without DISTINCT
Result with DISTINCT kwyword
No comments:
Post a Comment