From the sql referwence manual in a select statement:

DISTINCT | UNIQUE
Specify DISTINCT or UNIQUE if you want the database to return only one copy of each
set of duplicate rows selected. These two keywords are synonymous. Duplicate rows
are those with matching values for each expression in the select list.

However there are places where they are not interchangeable.



-----Original Message-----
From: Erik Slazyk [mailto:oracledba-ezmlmshield-x26794473.[Email address protected]
Sent: Monday, December 31, 2007 2:11 PM
To: LazyDBA Discussion
Subject: distinct VS unique

In SQL, what is the difference between distinct VS unique? I tried using both, and they both have given the same results. I look in a few different books, and found only information on Distinct.



Thanks in Advance,



Erik Slazyk

Catalpa Systems



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To unsubscribe: http://www.lazydba.com/unsubscribe.html




Oracle LazyDBA home page