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;




No comments:

Post a Comment