topic Re: Re: Read to an internal table with Aggreegate Function. in Application Development and Automation Discussions

Re: Read to an internal table with Aggreegate Function.

Former Member — Tue, 23 May 2006 08:41:02 GMT

Hi,

I wanted to find the Maximum and Minimum value from an internal table for each shipment number.

without calling select statement in loop.

I pulled all the data into an internal table. and i tried to read the data. through sorting the record ascending and descending.. but.. i wanted to know.. whether there is any best method to find it..

Thanks & Regards

Guhapriyan

Re: Re: Read to an internal table with Aggreegate Function.

Former Member — Tue, 23 May 2006 08:42:37 GMT

Hi,

I think SORTING and reading the table is best solution in the given situation.

Regards,

Ravi

Note : Please mark all the helpful answers

Re: Re: Read to an internal table with Aggreegate Function.

Former Member — Tue, 23 May 2006 08:45:41 GMT

If you only want to find min & max values, you can use aggregate functions in select stmt as well...

Re: Re: Read to an internal table with Aggreegate Function.

Former Member — Tue, 23 May 2006 08:54:10 GMT

Hi,

You can use the ORDER BY clause in the select statement itself.

Refer the demo program :

<b>DEMO_SELECT_ORDER_BY</b>

Reward points to all helpful answers and close the thread if your question has been answered.

Regards,

Amit Mishra