topic Re: select stm in Application Development and Automation Discussions

select stm

Former Member — Tue, 05 Jun 2007 11:17:16 GMT

SELECT c_{lifnr MAX( b}eindt )

SUM( b~menge ) ...........

what does this mean?

plz explain me

Re: select stm

Former Member — Tue, 05 Jun 2007 11:19:47 GMT

Hi,

1. It means that

2. From the table, there must be field lifnr,

3. So based on lifnr / grouped by lifnr,

fetch some numeric values,

4. In that,

against each lifnr,

we will get 2 numeric values

a) Maximum of eindt field

b) sum of menge field

regards,

amit m.

Re: select stm

Former Member — Tue, 05 Jun 2007 11:20:14 GMT

MAX( b~eindt ) - it will get latest date data from database table

SUM - it will calulate the all the values qty,in thi condition you need to add group by .

Message was edited by:

Seshu Maramreddy

Re: select stm

Former Member — Tue, 05 Jun 2007 11:20:52 GMT

You r selecting lifnr from one table for which u have given alias name as 'C', maximum number of eindt this field from a different table and you are summing up the quantity (menge).

Regards

Haritha.

Re: select stm

Former Member — Tue, 05 Jun 2007 11:21:45 GMT

the problem is i didnt got that MAX and SUM ?

What it will give

Re: select stm

Former Member — Tue, 05 Jun 2007 11:23:30 GMT

This syntax is used when you have join on multiple tables. To differentiate the

fields from different tables, tables are aliased .

Re: select stm

Former Member — Tue, 05 Jun 2007 11:23:44 GMT

it will sum all menge by SUM,

and the latest date is got by MAX,

regards

prabhu

Re: select stm

Former Member — Tue, 05 Jun 2007 11:24:57 GMT

Hi again,

1. Max and sum are called aggregate values.

2. Suppose we have

lifnr field 1 fiedl2

1 50 45

1 60 100

2 30 10

then for lifnr=1

Max (Maximum) will be 60

Sum (Total) will be 110

Similary for lifnr = 2

Max (Maximum) will be 30

Sum (Total) will be 10

regards,

amit m.

Re: select stm

Former Member — Tue, 05 Jun 2007 11:25:55 GMT

well it will select you the lifnr, the max of eindt and the sum of menge.

Tho its not too clever to sum wher you in first hand do a MAX. Since a MAX will get you ONE record only always.

the "~" symbol secifies that the select will be done down do the DB tables, not using an buffers or chaches or transparent tables.