Skip to Content
0
Former Member
Dec 04, 2006 at 04:02 PM

Data base select for latest record?

44 Views

I have database Z-table

ZPRCTR ZGJAHR ZMONAT RPT_LOC

0000000330 2006 01 0330

0000000330 2006 02 0330

0000000330 2006 03 0330

0000000330 2006 04 0330

If I give ZPRCTR = '0000000330'

then I need to get the record

0000000330 2006 04 0330 which is latest one...because of ZMONAT = '04'.

Right now by using select single or select up to 1 rows

i am getting the oldest record.

0000000330 2006 <b>01</b> 0330

How can I achieve this ?