This is something that comes up so often I almost stopped thinking about it but I'm almost certain that I'm not doing this the best way.
The question: Suppose you have the following table
CREATE TABLE TEST_TABLE ( ID INTEGER, TEST_VALUE NUMBER, UPDATED DATE, FOREIGN_KEY INTEGER );
What is the best way to select the TEST_VALUE associated with the most recently updated row where FOREIGN_KEY = 10?
EDIT: Let's make this more interesting as the answers below simply go with my method of sorting and then selecting the top row. Not bad but for large returns the order by would kill performance. So bonus points: how to do it in a scalable manner (ie without the unnecessary order by).