The WHERE clause is probably the most important part of the SQL statement and you will likely use it in most SQL queries. http://www.basewebmaster.com/sql/where-clause.php
The SELECT DISTINCT statement functions in much the same way as a standard select statement but will only return distinct column values. http://www.basewebmaster.com/sql/select-distinct.php