On Jan 7, 2008 4:27 PM, Richard Broersma Jr <rabroersma(at)yahoo(dot)com> wrote:
> --- On Mon, 1/7/08, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
>
> > select max(col1) from table
> > union all
> > select max(col2) from table
> > union all
> > select max(col3) from table
>
> Would the following work also?
>
> SELECT MAX( GREATEST( col1, col2, col3 ) )
> FROM TABLE;
Not given his example output. Given that output, he wants the max of
each column, and your example would only return a single value.