topic Re: SUM in Application Development and Automation Discussions

SUM

Former Member — Wed, 05 Dec 2007 15:07:22 GMT

Can SUM be used with a where clause in a select?

Thank-You.

Former Member — Wed, 05 Dec 2007 15:14:49 GMT

Hi,

No SUM is not used with where clause in a Select.

Plz Reward if Useful ,

Mahi.

Former Member — Wed, 05 Dec 2007 15:14:54 GMT

Message was edited by:

Jacek Slowikowski

Former Member — Wed, 05 Dec 2007 15:20:40 GMT

SUM can be used with a where clause but not within the where clause.

example

TABLES SBOOK.

DATA: COUNT TYPE I, SUM TYPE P DECIMALS 2, AVG TYPE F.

DATA: CONNID LIKE SBOOK-CONNID.

SELECT CONNID COUNT( * ) SUM( LUGGWEIGHT ) AVG( LUGGWEIGHT )

INTO (CONNID, COUNT, SUM, AVG)

FROM SBOOK

WHERE

CARRID = 'LH ' AND

FLDATE = '19950228'

GROUP BY CONNID.

WRITE: / CONNID, COUNT, SUM, AVG.

ENDSELECT.