How to write simple select clause for the following problem

From: Oliver Yao <oliveryao2000_at_yahoo.com>
Date: 15 Nov 2002 18:32:27 -0800
Message-ID: <d617ee1.0211151832.6057cdd6_at_posting.google.com>


Assume a table MYTABLE looks like the following:

MYTABLE:

  NAME      DATE1     DATE2     DATE3
   X      01/01/02   01/01/02  02/01/02
   Y      02/04/02   02/05/02  01/30/02
   Z      02/20/02   02/05/02  11/14/02

The problem is to find the last date (i.e. 11/14/02) in all three column DATA1, DATA2 and DATA3. Thanks. Received on Sat Nov 16 2002 - 03:32:27 CET

Original text of this message