Skip to content

Instantly share code, notes, and snippets.

@pedroinfo
Created March 19, 2025 18:18
Show Gist options
  • Save pedroinfo/fd1d3f5eff244d2087a7f3d59c267501 to your computer and use it in GitHub Desktop.
Save pedroinfo/fd1d3f5eff244d2087a7f3d59c267501 to your computer and use it in GitHub Desktop.
SELECT
mr.contrato,
mr.dt_inicio_vigencia_contrato AS dt_inicio_mf_receita,
mr.vl_receita_total AS receita_mf_receita,
mr.competencia AS competencia_mf_receita,
mr2.dt_inicio_vigencia_contrato AS dt_inicio_mf_receita_202501,
mr2.vl_receita_total AS receita_mf_receita_202501,
mr2.competencia AS competencia_mf_receita_202501,
CASE
WHEN mr.vl_receita_total = mr2.vl_receita_total THEN 'Iguais'
ELSE 'Diferentes'
END AS comparacao_receita
FROM mf_receita mr
LEFT JOIN mf_receita_202501 mr2
ON mr.contrato = mr2.contrato
AND mr.dt_inicio_vigencia_contrato = mr2.dt_inicio_vigencia_contrato
AND mr.competencia = mr2.competencia
WHERE mr.vl_receita_total <> mr2.vl_receita_total
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment