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

Since the OP failed to provide a version for his Oracle I do not know if he has those functions - ..

Brian Peasland <oracle_dba_at_remove_spam.peasland.com> wrote:

>> 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

----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Received on Wed Jun 11 2003 - 15:44:38 CDT