Oracle FAQ

Your Portal to the Oracle Knowledge Grid

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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Is it possbile to SUM the members of a group expression in SQL?

Re: Is it possbile to SUM the members of a group expression in SQL?

From: Fabio GRANDE <fabiog_at_fileita.it>
Date: Mon, 12 Nov 2001 08:50:30 +0100
Message-ID: <9sntp8$3en$1@fe2.cs.interbusiness.it>

This is the first use of GROUP BY clause... So Your query is right !
> SELECT name,date,sum(price) GROUP BY name, date

Fabio GRANDE Received on Mon Nov 12 2001 - 01:50:30 CST

This message: [ Message body ]
Next message: Student: "Re: Survey for Oracle and Datacraft"
Previous message: Nicholas Carey: "Re: SQL: discussion of GROUP BY clause"
In reply to: Gary Gapinski: "Re: Is it possbile to SUM the members of a group expression in SQL?"
Next in thread: Thomas Kyte: "Re: Is it possbile to SUM the members of a group expression in SQL?"

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