SQL Related Articles: Select with SUM
2002-12-04 -- Ray Goudie
Newsgroups: comp.lang.clarion
How about using the following:
---
SELECT CmpID, sum(case when Amt > 0 then Amt end) AS Debits,
sum(case when Amt < 0 then Amt end) AS Credits,
sum(case when Amt = 0 then Amt end) AS ZeroAmts
FROM GLFINAN
GROUP BY CmpID
---
-Ray.
"Ben Kim (Vertical Dimensions, Inc.)" wrote in
message news:3dee3396@news.softvelocity.com...
> Hello all,
>
> I am using MS-SQL 2K and using the following SELECT statement via the Query
> designer. However, I am not sure why this statement does not work.
> According to the SQL online docs the SUM aggregate function allows for an
> expression. Here is the statement:
>
> SELECT CmpID, SUM(Amt > 0) AS Debits, SUM(Amt < 0) AS Credits, SUM(Amt =
> 0) AS ZeroAmts
> FROM GLFINAN
> GROUP BY CmpID
>
> It does not like any of the SUM statements. If I just use SUM(Amt) As
> EndingBalance it works fine. Obviously I am misinterpreting the books
> online or this is just not possible.
>
> Thanks!
>
> Ben Kim
>
>
Printed May 4, 2024, 1:35 am
This article has been viewed/printed 35118 times.
Google search
has resulted in 21 hits on this article since January 25, 2004.