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!

COUNT DISTINCT IF

823581Dec 13 2010 — edited Dec 14 2010
I'm trying to do the following:


SELECT COUNT (DISTINCT TEMP (IF TEMP <> '@')) FROM TABLE1 GROUP BY ORDER_NUM;


In other words I want to count, for each order number the number of unique/distinct temp values that are not equal to an '@' character.

Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 11 2011
Added on Dec 13 2010
5 comments
2,008 views