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
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-
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
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
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
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
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
8 matches
Mail list logo