Posts by Wellington Nowicki • 3 points
2 posts
-
0
votes1
answer32
viewsQ: 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…
-
0
votes0
answers247
viewsQ: 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…