Posts by Wellington Nowicki • 3 points

• 0

  votes

  1

  answer

  32

  views

  Q: DISTINCT in a WHERE Oracle

  I need to return the last two purchases of each table item NOTA_FISCAL_ENTRADA_ITEM, but returns column values VL_UNITARIO_ENTRADA_EST different. That is, if in the last two purchases the value is…

  sql oracle distinct

  asked 3 years, 2 months ago Wellington Nowicki 3

• 0

  votes

  0

  answers

  247

  views

  Q: Convert Column to Oracle Lines

  Good morning! I need the result of this SQL: SELECT CD_ITEM_PAI, CD_ITEM_FILHO FROM ESTRUTURA WHERE CD_ITEM_PAI = 707534 That at the moment is this: Be that as it may: Can you help me? Using PIVOT I…

  sql database oracle

  asked 4 years, 5 months ago Wellington Nowicki 3