How get maximum of two columns

From: <oracle_adam_at_nospam.com>
Date: 13 Aug 2003 21:20:53 GMT
Message-ID: <bhea3l$s4c$1@news.netmar.com>

I have two date columns in a table, DATE1 and DATE2.

How do I get the maximum of DATE1 and DATE2 in a select statement (no PL/SQL), something like SELECT MAXIMUM(DATE1,DATE2) FROM <TABLE>?

Many thanks

Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net

Received on Wed Aug 13 2003 - 16:20:53 CDT