OraQA

Oracle Question and Answer

  • Do you have a solution to a problem? Do you have an unanswered question? Login and share it with the Oracle community. More...

Oracle News


Entries RSS feed

Comments RSS feed

What is the difference between SELECT UNIQUE and SELECT DISTINCT?

August 7th, 2006 By Eddie Awad

DISTINCT and UNIQUE are synonymous. For example:

SELECT DISTINCT object_type
    FROM user_objects;

is the same as:

SELECT UNIQUE object_type
    FROM user_objects

Resources:

Leave a Reply

You must be logged in to post a comment.

RSS feed for comments on this question