Re: Help? Select latest and earliest date from a row containing three dates.

> You can use the MIN and MAX functions in SqlPlus to get the low and high, but the middle will be a problem;
> - middle has no real meaning to Oracle.
>

It all depends on what one means by "middle". Do they mean middle as in the rank, or dense_rank? Or, do they mean middle as in median or average? All of which can be easily computed by SQL functions.

HTH,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"