hello!!
when I try to perform the following query returns me this error:
SELECT PERSONA, ENERO,FEBRERO,MARZO,ABRIL
FROM ( SELECT PERSONA,MES,MONTO FROM EJEMPLO) AS TablaDato
Pivot
(
sum(monto)
For mes IN (ENERO,FEBRERO,MARZO,ABRIL)
) AS PIVOTABLE;
when using the "AS" ERROR APPEARS
Someone knows why??????