Use of the SQL MAX statement.

UKDeej

New Member
Simply a table with an item code and then two revision numbers.

I can report on the item, revisionA and revisionB and sort the revisions in descending order. All through standard Actuate options of course.

Now need to report on the maximum revisionA and revisionB for any item with an input of the item only. Recognise this would mean amending the SQL code; but not sure where to begin.

I would think such is quite straightforward to those in the know; but as I come from an IBM RPG background my coding skills are not the best when it comes to Progress / Actuate!

Any assistance appreciated.
 
Top