Wednesday, January 30, 2019
Convert Rows to columns
SELECT * FROM(
SELECT no_akaun, kod_hasil, debit, kredit FROM etlejer2018
) pivot
(
SUM(debit-kredit) FOR kod_hasil IN ('61101', '76101', '76102', '76103')
)
ORDER BY no_akaun;
Labels:
Oracle (SQL)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment