Advertisement

10.14.2004 at 11:43AM PDT, ID: 21168753
[x]
Attachment Details

SQL UNIQUE and DISTINCT

Asked by benpung in Oracle Database

Tags: unique, sql, select

Oracle 8i, HP UX server.  Can someone tell me the difference (if any) between the oracle UNIQUE and DISTINCT keywords?  They seem to work exactly the same.  If I say:

SELECT UNIQUE(COLUMN) FROM TABLE

i get the same results as saying

SELECT DISTINCT(COLUMN) FROM TABLE

Is there some internal difference in how to two of them operate on the tables they are selecting from or something?  thanks.Start Free Trial
[+][-]10.14.2004 at 11:58AM PDT, ID: 12311173

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Oracle Database
Tags: unique, sql, select
Sign Up Now!
Solution Provided By: markgeer
Participating Experts: 5
Solution Grade: B
 
 
[+][-]10.14.2004 at 12:04PM PDT, ID: 12311235

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.14.2004 at 08:25PM PDT, ID: 12315786

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.14.2004 at 08:48PM PDT, ID: 12315874

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.15.2004 at 02:51AM PDT, ID: 12317406

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.15.2004 at 07:50AM PDT, ID: 12320147

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.15.2004 at 07:59AM PDT, ID: 12320246

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.18.2004 at 05:44AM PDT, ID: 12337732

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04.21.2005 at 03:13AM PDT, ID: 13832101

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.21.2005 at 12:20PM PDT, ID: 13837240

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32