View Full Version : the average of how old the "newest" file is in a table?

05-22-2007, 03:30 PM
How do I get the "average of HOW old the "newest" file is" using Oracle from a Table? any idea??
let say for example I have a table called A and I want to know HOW OLD is the NEWEST FILE in that table!!

05-22-2007, 05:48 PM
Just order by creation, which I'd assume is the default. The just grab the first result. Probably best if you use a table to track the date it was created, then it's easy. Order by that, then display that on the result.

I have no idea why you're calling this an "average" and saying "newest", since the two terms are quite different.