Hi,
I am trying to get part all revision with maximum generation using IOM:
below are the entries:
Item Number Generation Revision
Testnumber1 1 00
Testnumber1 2 00
Testnumber1 3 00
Testnumber1 4 00
Testnumber1 5 00
Testnumber1 6 00
Testnumber1 7 00
Testnumber1 8 01
Testnumber1 9 01
Testnumber1 10 02
so from above entries I want:
Item Number Generation Revision
Testnumber1 7 00
Testnumber1 9 01
Testnumber1 10 02
I got this result with below SQL:
select item_number, MAX(generation) as generation, major_rev
from innovator.PART
group by item_number, major_rev order by generation
but how to do this with IOM?
Regards,
Maddy.