Hey guys i think its a JSP forum, since when did this turn into a database related forum.
-----Original Message----- From: A mailing list about Java Server Pages specification and reference [mailto:[EMAIL PROTECTED] Behalf Of Ed Ventura Sent: Wednesday, June 04, 2003 1:16 AM To: [EMAIL PROTECTED] Subject: Re: Multiplying two columns and then adding up all the records. How would I incorporate the code into my sql statement below: SELECT * FROM DOC.BCCHECKLIST WHERE STARTTIMEDATE BETWEEN TO_DATE('varSTARTDATE','mm/dd/yyyy') AND TO_DATE('varENDDATE','mm/dd/yyyy') ORDER BY STARTTIMEDATE DESC Thanks, Ed. > From: Clayton Nash <[EMAIL PROTECTED]> > Reply-To: A mailing list about Java Server Pages specification and reference > <[EMAIL PROTECTED]> > Date: Tue, 3 Jun 2003 17:01:10 +0100 > To: [EMAIL PROTECTED] > Subject: Re: Multiplying two columns and then adding up all the records. > > Select sum(pagecount*pages) > > Clayton > ----- Original Message ----- > From: "Ed Ventura" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, June 03, 2003 4:58 PM > Subject: Multiplying two columns and then adding up all the records. > > >> How do I multiply two columns and then add them all up from a resultset? > My >> database looks like this: >> >> CLIENT PAGECOUNT PAGES >> Xyzco 10 1 >> Abcco 5 3 >> Defco 3 6 >> >> So I need to multiply PAGECOUNT X PAGES for each record and then add them >> all up to get a total. In this example I would need to multiply (10 x 1) + >> (5 x 3) + (3 x 6) = grandtotal. >> >> Thanks for any help, >> Ed. >> >> > =========================================================================== >> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > JSP-INTEREST". >> For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST > DIGEST". >> >> Some relevant archives, FAQs and Forums on JSPs can be found at: >> >> http://java.sun.com/products/jsp >> http://archives.java.sun.com/jsp-interest.html >> http://forums.java.sun.com >> http://www.jspinsider.com >> > > =========================================================================== > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > JSP-INTEREST". > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". > > Some relevant archives, FAQs and Forums on JSPs can be found at: > > http://java.sun.com/products/jsp > http://archives.java.sun.com/jsp-interest.html > http://forums.java.sun.com > http://www.jspinsider.com =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant archives, FAQs and Forums on JSPs can be found at: http://java.sun.com/products/jsp http://archives.java.sun.com/jsp-interest.html http://forums.java.sun.com http://www.jspinsider.com =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant archives, FAQs and Forums on JSPs can be found at: http://java.sun.com/products/jsp http://archives.java.sun.com/jsp-interest.html http://forums.java.sun.com http://www.jspinsider.com
