Neoview SQL Reference Manual (R2.4)

(EXPR)VALCOL2VALCOL1KEYCOL
1e2?5
1f2?6
1d1?4
1e1?5
1f1?6
• This query shows how an item in the transpose item list can contain a list of expressions
and that the KEY BY clause is optional:
SELECT * FROM mytable
TRANSPOSE (1, A, 'abc'), (2, B, 'xyz')
AS (VALCOL1, VALCOL2, VALCOL3);
The result table of the TRANSPOSE query is:
VALCOL3VALCOL2VALCOL1FEDCBA
abc11f1e1d1100101
xyz102f1e1d1100101
abc21f2e2d2200202
xyz202f2e2d2200202
TRANSPOSE Clause 315