Archives of the TeradataForum

Message Posted: Thu, 25 Aug 2005 @ 22:03:45 GMT

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

Hi

Any idea if teradata has a Row to Column function just like oracle

Examples on how to use RowToCol Function:

Example 1: Where rows to be converted to a column string come from different table.

     SELECT a.deptno, a.dname, a.loc,
     rowtocol('SELECT DISTINCT job FROM emp WHERE deptno = ' ||a.deptno) as jobs
     FROM dept a;

Thanks

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