SELECT *, SUM(units) subtotal FROM table GROUP BY date
- do you mean this?
Mike Smith wrote:
I'm trying to present a simple SELECT statement GROUPED by date.
Ex.
WOUNITSOEMCOMMENTSDATE
123 10MeNotes03/18/2003
456 5
: Marek Kilimajer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 19, 2003 8:19 AM
To: Mike Smith
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] Subtotal
SELECT *, SUM(units) subtotal FROM table GROUP BY date
- do you mean this?
Mike Smith wrote:
I'm trying to present a simple SELECT statement GROUPED
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] Subtotal
SELECT *, SUM(units) subtotal FROM table GROUP BY date
- do you mean this?
Mike Smith wrote:
I'm trying to present a simple SELECT statement GROUPED by date.
Ex.
WOUNITSOEMCOMMENTS
Voigt [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 19, 2003 8:37 AM
To: Mike Smith
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP] Subtotal
Umm, add:
SUM([rushqty]) AS 'rushsub'
To your select, wouldn't that work?
On Wed, 2003-03-19 at 11:19, Mike Smith wrote:
Here is my query (MSSQL 2000
I'm trying to present a simple SELECT statement GROUPED by date.
Ex.
WOUNITSOEMCOMMENTSDATE
123 10MeNotes03/18/2003
456 5 You More Notes 03/18/2003
Total 15
...
I have it working grouping the
5 matches
Mail list logo