Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

HI. Doubt with "Distinct"

User553887-OracleJan 18 2007 — edited Jan 22 2007
HI,

I have a table called "tab" with 2 colums "col1" and "col2", having the values as follows.

col1 col2
1 2
2 2.

Now, I need the output report to be having col1, and col2 with those values which are distinct ( in both the colums, if seen individually). In other words, here i need output as
col1 col2
1 2 . I should not get the record " 2 2" anymore.

Im not able to achieve this using distinct. Please help. ( this is just the actual problem .My production tables and data are different though !).

Rgds,
Suman

Comments

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

Post Details

Locked on Feb 19 2007
Added on Jan 18 2007
18 comments
2,638 views