Read to an internal table with Aggreegate Function.

[Former Member]

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

[Former Member]

Hi,

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

Regards,

Ravi

Note : Please mark all the helpful answers

[Former Member]

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

[Former Member]

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