Posts by LPedrosa • 17 points
4 posts
-
0
votes1
answer174
viewsQ: Select Distinct in only one of the tables
I have the following separate tables, A and B which I am placing next to each other to facilitate: +--------------+------------+-------------+ |ID Relacional | A | B |…
-
0
votes1
answer69
viewsQ: Select different conditions for the same column
I have the following table with my current query. Data | PesoTotal 01/04/2019 | 500 02/04/2019 | 800 And I would like to add a new column (Pesohorario), which would be the Peso on the date, but…
-
0
votes1
answer88
viewsQ: Date range query in a given time
I have a query that takes all the data between days. However, I would like him to take this data only in an interval of hours (from 08:00 to 17 for example). My query currently looks like this:…
-
0
votes1
answer64
viewsQ: Exit a method call cycle
Let’s imagine the following situation: A company has the policy of donating 3% of its profit to social projects, and this amount donated should come as an expense to the company in the period.…