Unique keyword in SQL

http://www.w3schools.com/SQl/sql_unique.asp
http://stackoverflow.com/questions/336268/sql-difference-between-select-unique-and-select-distinct