How to write simple select clause for the following problem
From: Oliver Yao <oliveryao2000_at_yahoo.com>
Date: 15 Nov 2002 18:40:15 -0800
Message-ID: <d617ee1.0211151840.372be2bf_at_posting.google.com>
Date: 15 Nov 2002 18:40:15 -0800
Message-ID: <d617ee1.0211151840.372be2bf_at_posting.google.com>
Assume a table MYTABLE looks like the following:
MYTABLE:
The problem is to find the last date (i.e. 11/14/02) in all three column
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