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