2006 Nov 16 1:17 PM
Hi there. I'm using ADA logical database to perform data selection. After I select data from certain table, I have to restrict the result with another selection. How can I select the max value from table ANEP?
2006 Nov 16 1:22 PM
Select max(Fieldname here) from ANEP into WORK_AREA where MENTION_CONDITION
I hope it helps.
Best Regards,
Vibha
*Please mark all the helpful answers
Hi there. I'm using ADA logical database to perform data selection. After I select data from certain table, I have to restrict the result with another selection. How can I select the max value from table ANEP?
2006 Nov 16 1:19 PM
u get data to variable/internal table. now loop this and using another data selection u can restrict the values.
2006 Nov 16 1:22 PM
Select max(Fieldname here) from ANEP into WORK_AREA where MENTION_CONDITION
I hope it helps.
Best Regards,
Vibha
*Please mark all the helpful answers
2006 Nov 16 1:22 PM
Hi,
You may go like this -
Get <struct/tab>.
.
.
if tab-field <= v_value. (to select values greater than v_value.
reject.
End-of-selection.
Regards,
Amit
2006 Nov 16 1:31 PM
| User | Count |
|---|---|
| 6 | |
| 3 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |