Skip to Content
0
Former Member
Jun 08, 2009 at 09:57 AM

How to select a max value in a database table for display

8879 Views

Dear Experts

I have a Z database table.

In that i have three fields.

Review Cycle Review step GUID of object

1 1 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

1 2 xxxxxxxxxxxxxxxxxxxxxxxxxxxxx

2 1 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

2 2 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

3 1

Here my requirwement for output dispay is that i need to select review_cycle 3 only.

Should i add counter in the loop when i loop at this internal table and display the counter value ?

Thanks in advance