Re: Help with MIN field value
Date: Fri, 19 Sep 2003 22:02:48 GMT
Message-ID: <c2Lab.66130$DZ.58777_at_news04.bloor.is.net.cable.rogers.com>
Look up LEAST function
"Marc A. Lefebvre US-775" <lefebvre_at_iwavesolutions.com> wrote in message
news:5ef1a86c.0309191233.79cdb6b3_at_posting.google.com...
> I have table FOO, fields F1, F2, F3, F4, and F5.
>
> I need a single SELECT statement on FOO that returns the LOWEST date
> between the five fields.
>
>
> So, if table records looked like
>
> FOO:
> F1 F2 F3 F4 F5
> 3/25/03 3/12/03 3/10/03 3/15/03 3/22/03
> 5/03/03 5/10/03 5/22/03 5/22/03 5/03/03
> 9/10/03 9/09/03 9/12/03 9/01/03 9/15/03
>
> The select statement would return:
> 3/10/03
> 5/03/03
> 9/01/03
>
>
> Again, this would need to work in a single select statement. If it is
> impossible, then if a stored procedure could be used, please show
> that.
>
> Thanks!!
>
> Marc
Received on Sat Sep 20 2003 - 00:02:48 CEST