Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 Oracle PL/SQL: Distinct Jump to:  
Category: >> Oracle PL/SQL >> Distinct Bookmark and Share

<< lastnext >>

Snippet Name: Distinct

Description: The DISTINCT clause allows you to remove duplicates from the result set. The DISTINCT clause can only be used with select statements.

Also see:
» AND Condition
» Having Clause
» EXISTS 2
» EXISTS
» WITH with CONNECT BY
» WITH Clause: Single alias
» WITH Clause: Double alias

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:
 
SELECT DISTINCT columns
FROM tables
WHERE predicates;
 
Let's take a look at a very simple example.
 
SELECT DISTINCT city
FROM suppliers;
 
This SQL statement would return all unique cities from the suppliers table.


Free
Oracle Magazine
Subscriptions
and Oracle White Papers


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.

Click here to find out more
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 321 users online    © 2009 psoug.org

PSOUG LOGIN
Username: 
Password: 
Forgot your password?