On Jan 7, 2008 4:27 PM, Richard Broersma Jr <[EMAIL PROTECTED]> wrote: > --- On Mon, 1/7/08, Scott Marlowe <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
