Archives of the TeradataForum

Message Posted: Thu, 18 Sep 2003 @ 05:08:47 GMT

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

Sounds like making use of a transpose(w.r.t matrix) like function which would look like

Select max(c1),max(c2)...
      FROM (Select transpose(f1,f2 .......) from tblname)
dervtmp(c1,c2,....);

But I guess something like the transpose ain't an inbuilt function available?

Narayan.

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