SUM

[Former Member]

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

Thank-You.

[Former Member]

Hi,

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

Plz Reward if Useful ,

Mahi.

[Former Member]

no

Message was edited by:

Jacek Slowikowski

[Former Member]

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.