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.

count distinct combinations

518523Feb 15 2007 — edited Feb 16 2007
I have a table which has 3 columns a, b, c
there could be duplicates in a/b/c.
I want to count the total number of distinct combinations of a, b, c using a select query (i.e. the result of the select query should be the count). How do I do this?

Comments

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

Post Details

Locked on Mar 16 2007
Added on Feb 15 2007
24 comments
127,004 views