Posts by Vinicius Ferreira • 41 points
3 posts
-
1
votes5
answers35616
viewsA: SELECT condition WHERE with multiple values in the same column
The absence of the profile table model makes the answer difficult, but: FROM people AS p LEFT JOIN profile AS c ON p.pid = c.perfil_person One of the bugs is just above, c.perfil_pessoa has to be…
-
1
votes1
answer58
viewsQ: SQL does not calculate with NULL values
I have a query where I have 3 columns grouped and last totaling 3, the problem is for Edson the query is not TOTALING. TOTAL = CREDIT - (DISCOUNT + REBATES) The total Edson has to give 266,49 but my…
-
2
votes2
answers761
viewsA: Firebird - Select to join two or more lines
may be so too: select t.Cliente_id, CAST(SUM(t.credito) as numeric(15,2)), CAST(SUM(t.debito) as NUMERIC(15,2)), t.pedido, CAST(SUM(t.credito) as numeric(15,2)) - CAST(SUM(t.debito) as…