Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

distinct not working

536003Dec 18 2006 — edited Dec 19 2006
Hi all, I have a query like this:

select d.a, d.b, d.c, d.d
from table d, (select key
from other_table) c
where d.key = c.key
and d.incorrect is null;

My problem is I only need distinct a, b, c, d values. When i put distinct on select, statement does not work, it keeps executing and it shows no result.

select distinct d.a, d.b, d.c, d.d
from table d, (select key
from other_table) c
where d.key = c.key
and d.incorrect is null;

What´s wrong? Thanks.

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 16 2007
Added on Dec 18 2006
20 comments
4,619 views