DISTINCT!

This touches on DISTINCT and how it may be used in a query to remove duplicate records. I think this is an MSSQL only thing.

SELECT DISTINCT city, state
FROM suppliers;