Posts by Rui Caeiro • 1 point

• 0

  votes

  1

  answer

  253

  views

  A: Inner Join without duplicating lines, bring the first value found

  Try using the PIVOT clause, for example: https://www.techonthenet.com/oracle/pivot.php In practice it will be something like this: SELECT * FROM ( SELECT NR_ANO_MES, nr_contrato,NM_PRODUTO FROM…

  sql oracle

  answered 6 years, 10 months ago Rui Caeiro 1