COUNT DISTINCT IF
823581Dec 13 2010 — edited Dec 14 2010I'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.