Comment: Unique can be used in place of distinct. The effect is the same.
Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 07th, 2009
The syntax FOR the DISTINCT clause IS:SELECTDISTINCT columns
Let's take a look at a very simple example.
SELECT DISTINCT city
This SQL statement would return all unique cities from the suppliers table.
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.