Posts by Rafael Bernini • 3 points
5 posts
-
0
votes2
answers59
viewsA: How to make a SELECT to get the value of the last registered date
Man, thank you so much. That balcony hadn’t touched me, it opened my mind. I redid the code and left it that way based on what you gave me. I just have to thank. NCM, AD_PARTNUMBER, CTE.DTCONTAGEM,…
-
0
votes2
answers59
viewsQ: How to make a SELECT to get the value of the last registered date
Hello, I would like a help to always use the value of a table. I have a table "COSTS" and every month it suffers price change of the products, but are not all that has update My question is that…
-
0
votes1
answer24
viewsQ: How to create a read sequence in a Select field in the Oracle Database?
I have a problem in my code I would like a help with an excerpt of my code. the ITE.SEQUENCIA line did not want to leave the number 1 fixed, because it may be that an item is deleted and starts with…
-
0
votes2
answers67
viewsA: How to calculate the value of two subquery in Oracle SQL
Thanks to the cooperation of all, more I solved in this way: Thank you very much. , (SELECT NVL(SUM(TAB1.VLRTOTAL),0) FROM TABELA TAB1 WHERE TAB1.ID = TAB3.ID) AS VALOR_1 , (SELECT…
-
0
votes2
answers67
viewsQ: How to calculate the value of two subquery in Oracle SQL
How to calculate two subquery on Oracle? Could you explain to me how I sum up VALOR_1 + VALOR_2? SELECT COL1 , (SELECT SUM(TAB1.VLRTOTAL) FROM TABELA TAB1 WHERE TAB1.ID = TAB3.ID) AS VALOR_1 ,…