topic Re: select statement in Application Development and Automation Discussions

select statement

Former Member — Tue, 08 Apr 2008 13:40:17 GMT

hi all,

i need to select the oldest entry from a table based on particular field .

can there be a select where i select just 1 entry and that should be the oldest one?

OR i first select all data

then sort it decending

then??

what can be done

Former Member — Tue, 08 Apr 2008 13:46:58 GMT

you can do the following

selec max(<date column>) from <table>.

Former Member — Tue, 08 Apr 2008 13:47:21 GMT

Read all the entries of the table into an internal table.

Sort the internal table for that field or date

Read the internal table with key....which would pick the first record...(oldest one in your case)

hope it helps

thanks