select statement

[Former Member]

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]

you can do the following

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

[Former Member]

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