Difference between Distinct and Unique
This is a discussion on Difference between Distinct and Unique within the Oracle Miscellaneous forums, part of the Oracle Database category; --> Hi Experts!!! I can't tell the dfference between Distinct and Unique. Does anyone know? Thanks, Peiyi...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-08-2008, 10:27 AM
| |||
| |||
 Re: Difference between Distinct and Unique "PW" <wupeiyi2@hotmail.com> wrote in message news:1147434692.734264.136890@d71g2000cwd.googlegr oups.com... : Hi Experts!!! : I can't tell the dfference between Distinct and Unique. : Does anyone know? : : Thanks, : Peiyi : in what context? ++ mcs      |
|
04-08-2008, 10:27 AM
| |||
| |||
| Re: Difference between Distinct and Unique 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 -- |
|
04-08-2008, 10:27 AM
| ||||
| ||||
| Re: Difference between Distinct and Unique PW wrote: > Hi Experts!!! > I can't tell the dfference between Distinct and Unique. > Does anyone know? > > Thanks, > Peiyi One starts with the letter "D" the other with "U". -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org |
 |
« DROP or MODIFY COLUMN on Oracle 8 system
|
Oracle Clinical : Checking for missing test parameters »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 06:22 AM.
