topic Re: fetch last record from database table in Application Development and Automation Discussions

fetch last record from database table

Former Member — Fri, 11 Dec 2009 11:59:29 GMT

hi,

how to fetch last record from database table.

plz reply earliest.

Regards,

Jyotsna

Moderator message - Please search before asking - post locked

Edited by: Rob Burbank on Dec 11, 2009 9:44 AM

Re: fetch last record from database table

Former Member — Fri, 11 Dec 2009 12:03:53 GMT

Hello,

Select single * from <table> order by <keyfield> desc.

Thanks

manish

Re: fetch last record from database table

Former Member — Fri, 11 Dec 2009 12:10:45 GMT

must be something with select..i tried but wasn't able to find...

selecting in descending order might not work...

select all the data..

describe the internal table.

and then read with index.

hope it helps

regards

Yadesh

Re: fetch last record from database table

Former Member — Fri, 11 Dec 2009 12:15:06 GMT

Hi Jyotsana,

Do as below :-

SELECT single FIELD1 FIELD2 from table into TABLE ITAB WHERE FIELD1 = 'VALUE'.

ENDSELECT.

LOOP AT ITAB into WA.

Do nothing....

ENDLOOP.

Here WA will be having the last record.

Regards

Abhii

Re: fetch last record from database table

Former Member — Fri, 11 Dec 2009 12:22:32 GMT

abhi,

just imagine the table to be BSEG or FAGLFLEXA... then what would be performance of the code ?

any ways,

jyotsna, first check if you have a pattern to follow like if the primary key field have a increasing number range or it would be great if you find a date field which stores the inserted date or some thing..

you can select max or that field or order by descending using select single.

or get all data.. sort in descending order.(again you need some criteria like date).

read the first entry. using read itab index 1