The select statement would be
select least(f1,f2,f3, f4,f4) from foo;
lefebvre@iwaves olutions.com (Marc A. Lefebvre US-775) wrote in message news:<5ef1a86c. 0309191233.79cd b6b3@posting.go ogle.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
>
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
Leave a comment: