I'm looking for a solution for my problem. (aren't we all )If have several 1000 of actions performed every hour / machine --> towards oracle db. What I need do now is to retrieve the record with the most recent date. My record contains several info and one of them is a date field.
How can I retrieve the most recent record whithout having to sort them first on date an then select the last or first record depending on my sort order.