Re: SQL sum question

2007-05-18 Thread Gareth Hughes
I really should have been able to figure that out. Hopefully I'll remember next time :) Many thanks Jochem. - Original Message - From: "Jochem van Dieten" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Friday, May 18, 2007 12:36 PM Subject: Re: SQL sum

Re: SQL sum question

2007-05-18 Thread Jochem van Dieten
Gareth Hughes wrote: > select pname,sum(pagehit) as pagehit > where dates between x and y > group by pname, pagehit > order by pagehit desc, pname select pname,sum(pagehit) as pageHitCumul where dates between x and y group by pname order by sum(pagehit) desc, pname Jochem

RE: SQL SUM Question

2001-01-04 Thread bflynn
Just to add a comment to what everyone else has said - I've always seen different syntax on this. select SUM(Number) "NUMBER" from Tbl_Numbers May be an Oraclism or just local teaching. I'm not that well versed in the differences between MSSQL and Oracle SQL. Brian -Original Message-

RE: SQL SUM Question

2001-01-03 Thread Joshua Tipton
Thats right I gorgot the as > -Original Message- > From: Kurt Ward [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 03, 2001 4:40 PM > To: CF-Talk > Subject: RE: SQL SUM Question > > > Select Number from Tbl_Numbers SUM(Number) AS MyVar > > #MyV

RE: SQL SUM Question

2001-01-03 Thread Joshua Tipton
select number sum(number) from tbl_numbers #number# I think that is right I would try it > -Original Message- > From: Kevin Queen [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 03, 2001 4:36 PM > To: CF-Talk > Subject: SQL SUM Question > > > List, > If I run the following quer

RE: SQL SUM Question

2001-01-03 Thread LKHaas
You have to select it as something, for example: select sum(number) as sum_number from Tbl_Numbers Regards, Lisa Haas The Kennedy Center -Original Message- From: Kevin Queen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 03, 2001 4:36 PM To: CF-Talk Subject: SQL SUM Question List

Re: SQL SUM Question

2001-01-03 Thread Ricq Pattay
Wouldn't that be: select sum(number) as whatever from Tbl_Numbers and then #get_sum.whatever# ? - Original Message - From: "Kevin Queen" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 03, 2001 3:36 PM Subject: SQL SUM Question > List, > If I run the

RE: SQL SUM Question

2001-01-03 Thread Kurt Ward
Select Number from Tbl_Numbers SUM(Number) AS MyVar #MyVar# -Original Message- From: Kevin Queen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 03, 2001 4:36 PM To: CF-Talk Subject: SQL SUM Question List, If I run the following query: Select Number from Tbl_Numbers SUM(Number) h