Re: Using TO_CHAR With Subtraction and AVG Function

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 19 Dec 2006 16:40:18 +0100
Message-ID: <458807e1$0$27879$426a34cc@news.free.fr>

<ITAnnaJones_at_gmail.com> a écrit dans le message de news: 1166539763.064195.49120_at_i12g2000cwa.googlegroups.com... Thank you so much, that worked great.

Would Group By have worked?

You cannot have the detail and aggregate values in this case unless you use a subquery for the aggregate values and correlate it with the outer one for the details.

Regards
Michel Cadot Received on Tue Dec 19 2006 - 09:40:18 CST

This message: [ Message body ]
Next message: sybrandb: "Re: Files not found in Oracle 9iAS"
Previous message: tacrawford_at_adelphia.net: "procedure called by trigger can't see new data"
In reply to: ITAnnaJones_at_gmail.com: "Re: Using TO_CHAR With Subtraction and AVG Function"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US