Posts by Ranier Cordeiro • 148 points
7 posts
-
4
votes2
answers72
viewsQ: Know which values within the IN condition are not linked to the table
Hello, I have a very simple table as an example: I also have a query that checks the existing values within the IN, example: SELECT * FROM tLetras l WHERE l.letras IN…
-
3
votes2
answers2244
viewsA: How to calculate the cumulative sum in Oracle
I managed using "Oracle Analytic Function" "Sum() Over()" select trunc(td.data_emissao) as data_emissao ,count(*) as emitidos ,sum(count(*)) over(order by trunc(td.data_emissao) rows between…
-
1
votes2
answers2244
viewsQ: How to calculate the cumulative sum in Oracle
Hello, I have a table with a lot of data, and I would like to count the amount of records in each date of this month. So far OK, a COUNT(*) and a GROUP BY already resolves. SELECT…
-
0
votes3
answers69
viewsA: Mysql - Query using Between to know if item is reserved on date/time
I understand you want to check if there are any reservations at the specified time. There are 4 hypotheses for such a condition to be true. There is a reservation prior to start date of the…
mysqlanswered Ranier Cordeiro 148 -
2
votes1
answer54
viewsA: How to calculate the total value considering a given attribute as increment or decrement parameter?
I created an example according to the information you made: The formula that is contained in the cell K3, representing the Balance current: =SOMA(C:C;G:G) - ( SOMASES(C:C;B:B;"C") +…
excelanswered Ranier Cordeiro 148 -
1
votes2
answers111
viewsA: Excel function recognizes "" as 0
In addition to the response of Wictor Chaves, can also be done as follows: =SE(E4&1="01";"0x0";"") So even if it passes through an empty cell(""), will return the value phony of condition if…
excelanswered Ranier Cordeiro 148 -
2
votes2
answers218
viewsA: How to add only the highest values of a numerical sequence in Excel?
Another way to do the formula, in addition to what @Bulfaitelo mentioned, is to add a "&" between the comparison signal and the value area. Example: =SOMASE(B51:B60; ">" & 600) With this…
excelanswered Ranier Cordeiro 148