This is the Forum for SQL Developer Data Modeler.
I suggest you try asking your question in the SQL and PL/SQL Forum: https://community.oracle.com/community/developer/english/oracle_database/sql_and_pl_sql
SELECT PERSONA, ENERO,FEBRERO,MARZO,ABRIL
FROM ( SELECT PERSONA,MES,MONTO FROM EJEMPLO)TablaDato
For mes IN (ENERO,FEBRERO,MARZO,ABRIL)
AS will be used for alias naming either a table or column. Here you are aliasing a SELECT query so you should not use AS keyword. And one more AS keyword you have used at the last after pivot. What is that for? If you want to alias SUM(MONTO) then you have to use it there as SUM(MONTO) AS PIVOT_TABLE. Pivoting is converting rows to columns, so you cant create a common alias name using AS clause at the last
Message was edited by: Parth272025