Archives of the TeradataForum

Message Posted: Wed, 17 Sep 2003 @ 14:21:28 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Wednesday, September 17, 2003 09:55 -->

I need function similar to GREATEST in oracle. We can use MAX agg function to find maximum of a field in a table. But I need maximum of N numbers. For Example : If a table has n different amount fields (amount1, amount2, ....... Amount n), I need maximum of all the amounts for each record in the table,

Thanks!

	<Prev	Next>		<<First	<Prev	Next>	Last>>