Snippet Name: SELECT: Get DISTINCT or UNIQUE values
Description: The UNIQUE command retrieves only unique data entries depending on the column list you have specified after it.
There is no difference between DISTINCT and UNIQUE. The UNIQUE keyword was Oracle's descriptor, but ANSI standards later defined DISTINCT as the 'official' keyword. Oracle then added DISTINCT but for the sake of for backward compatibility, did not decommission the UNIQUE keyword.