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 cf-talk@houseoffusion.com
Sent: Friday, May 18, 2007 12:36 PM
Subject: Re: SQL sum question
Gareth
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
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-
Select Number from Tbl_Numbers SUM(Number) AS MyVar
cfoutput#MyVar#/Cfoutput
-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
Wouldn't that be:
cfquery datasource=#variable.ds# name="get_sum"
select sum(number) as whatever from Tbl_Numbers
/cfquery
and then
cfoutput#get_sum.whatever#/cfoutput
?
- Original Message -
From: "Kevin Queen" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday,
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
select number sum(number)
from tbl_numbers
cfoutput query
#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
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
cfoutput#MyVar#/Cfoutput
-Original Message
8 matches
Mail list logo