Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Difference between Distinct and Unique

Re: Difference between Distinct and Unique

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 12 May 2006 07:34:19 -0700
Message-ID: <1147444458.968349.85930@u72g2000cwu.googlegroups.com> 





Mark is right what context?



Normally in SQL the keyword DISTINCT is used in a query select list to
eliminage duplicate rows from the result set of the query.  While the
term unique is used in relation to unique indexes, unique constraint,
or in describing unique keys.  In these three cases there will be no
duplicates for the column values used in the unique constrain and/or
index definition.



HTH -- Mark D Powell --
Received on Fri May 12 2006 - 09:34:19 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US