Posts by Matheus • 1 point

• 0

  votes

  3

  answers

  44

  views

  A: Return larger field to ID

  I got it this way: SELECT A.controle, A.codprod, A.vlrvenda FROM TGFEXC A LEFT JOIN TGFEXC B ON A.codprod = B.codprod AND B.nutab > A.nutab where B.nutab IS NULL Thank you all!…

  sql oracle

  answered 5 years, 6 months ago Matheus 1

• 0

  votes

  3

  answers

  44

  views

  Q: Return larger field to ID

  Good morning, I need some guidance regarding the following situation: In this table I need to return only the MAX(nutab) for each codprod and control. I tried using the MAX, but so only returned…

  sql oracle

  asked 5 years, 6 months ago Matheus 1