Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> about crosstab query
I need to translate this crosstab query to oracle
TRANSFORM Avg([PRICE1]) AS [The Value]
SELECT [CODE]
FROM ITEMS
GROUP BY [CODE]
PIVOT [GROUP];
Thanks
Qianli Luo Received on Thu Apr 29 1999 - 18:11:25 CDT