Skip to Content
0
Former Member
Jun 02, 2008 at 05:05 AM

how to get the latest record that was created in the table

44 Views

how do we get the latest record that was created..... for example

i want a select query which should get teh latest created record for this following logic

Retrieve the Cond. Record no KONH- KNUMH from table KONH by the condition : Where KONH-KOTABNR = u2018509u2019 and KONH-KSCHL = u2018JCEPu2019 and compare the first 16 characters of value of field KONH-VAKEY with concatenated value of MARC-HERKL &MARC-WERKS &MARC-STEUC with the latest created on KONH-ERDAT