Snippet Name: SELECT: Get DISTINCT / 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.
SQL University.net courses meet the most demanding needs of the business world for advanced education
in a cost-effective manner. SQL University.net courses are available immediately for IT professionals
and can be taken without disruption of your workplace schedule or processes.
Compared to traditional travel-based training, SQL University.net saves time and valuable corporate
resources, allowing companies to do more with less. That's our mission, and that's what we deliver.