Use a CASE function to classify the bills, check it out in the fine Oracle® Database SQL Language Reference.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
Forum Rules
Reply With Quote