First page Back Continue Last page Graphics

When to use distinct and when not to


Notes:

Note:
Except automatically removes duplicates so we do not have to write distinct.
Note:
The subquery construct count(*) does not eliminate duplicates.