Posts by Celio Sartori • 41 points
6 posts
-
0
votes1
answer72
viewsQ: Select the value of a field depending on a date
I have a table with the fields DT_FIMCALCULO, VL_DEPREREVVIDAUTILACUMULADA e CD_SEQUENCIALBEM. And for each CD_SEQUENCIALBEM I have several DT_FIMCALCULO each with a VL_DEPREREVVIDAUTILACUMULADA…
-
1
votes3
answers671
viewsQ: Select that respects all values in a list
I need to set up a very simple select, but I’m having a hard time. SELECT SEQPRODUTO FROM MRL_PRODUTOEMPRESA WHERE STATUSCOMPRA = 'I' AND NROEMPRESA IN (1,2,3,4,5,6,7,8,9,11,13,14) I need to select…
-
-1
votes2
answers1365
viewsQ: "ORA-01417: a table may be Outer joined to at Most one other table"
I’m riding a select and I came across the following mistake: ORA-01417: a table may be Outer joined to at Most one other table SELECT A.SEQPESSOA, A.NUMERONF, A.NROEMPRESA, A.SEQPRODUTO,…
-
0
votes0
answers172
viewsQ: Add column to SQL considering some conditions to be valid
I’m trying to gather two pieces of information and I’m not getting it. I set up this SQL to bring me only the products that were purchased that had a discount through a contract. However this…
-
1
votes1
answer428
viewsQ: Add values and subtract values from another condition
Good afternoon I have a table named TITLE In it I have columns with name CODOPERACAO, VLROPERACAO, DTAOPERACAO I have 2 different records of CODOPERACAO that are: 16 = Inclusion of title 28 =…
-
1
votes2
answers718
viewsQ: SELECT that brings products active in one company and that are not active in all others
I have a table that shows products that are Active (A) or Inactive (I) in 16 branches. IE, has 16 lines for each product. I want to select all products that are Active (A) in Enterprise 16 and at…