Re: MIN and MAX function between colums

You can try something like

select min(c) from (select min(Coumn1) AS c from <Your table> union select min(Column2) AS c from <Your table>);

"Nicolas Bronke" <nb_at_trinity.de> a écrit dans le message news: 9rjiuj$lt2$02$1_at_news.t-online.com...
> Min and Max calculated something for one column. Does that also between
> columns like
>
> min(column1, column2) ?
>
> Thanks
>
> Nicolas
>
>
Received on Mon Oct 29 2001 - 07:23:25 CST