RE: Interactive SQL question

[Bill Erhardt <ERHARDT@xxxxxxxxxxxxx>]

You can get the column total with something like        
Select sum(Qty), sum(price), sum(Qty*price)
If you have to list qty, price, qty*price and then there total, I'm told you
can do this with a Union but I've never actually done it.


> -----Original Message-----
> From: Dennis Munro [SMTP:DMunro@badgerminingcorp.com]
> Sent: Friday, February 02, 2001 4:13 PM
> To:   Midrange List (E-mail)
> Subject:      Interactive SQL question
> 
> I'm running V4R5M0 & a beginner at SQL.
> 
> I am trying to find some information on how to "code" column totaling. I
> have a report that selects qty, price, (qty * price) from a file but I
> would
> like to total the three columns.  Looked through the Midrange archieves
> but
> you get tired of looking through 278 entries after 25 & they don't pertain
> to my question.
> 
> I found one book on the on-line info center named "SQL Programming
> Concepts"
> that has a very "brief" section on interactive SQL.  But nothing that
> gives
> any programming examples.
> 
> I've talked to the local technical college & Interactive SQL is the only
> AS/400 based SQL class they teach & that is probably what I will do.  The
> instructor said the class is very basic & I've fooled around enough to
> wonder about a waste of time (16 weeks) & money.  All I have to do is get
> a
> couple of hints & it would be worth the effort so I think it will happen.
> 
> Again, all I want to do is find some information on Interactive SQL.  How
> to
> total a column is what I am trying to accomplish.
> 
> Dennis Munro
> 
> "I love deadlines.  I especially like the whooshing sound they make as
> they
> go flying by."  Dilbert's Words Of Wisdom:
> 
> Badger Mining Corporation
> www.badgerminingcorp.com
> dmunro@badgerminingcorp.com
> (920) 361-2388
> 
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---