Hello guys,
I need to tranform columns into rows or rows into columns.
I'm using only SQL Cache.
The code:
SELECT
codRepresentante
,vendasAbril
,vendasAgosto
FROM
Ped.MetasRepresen
WHERE ano = 2024
The columns:
InterSystems Caché is a multi-model DBMS and application server. See more details here.