Posts by Ale Suzuki • 36 points
4 posts
-
1
votes1
answer31
viewsA: Filter query for mysql dates
You did not enter the time together with the time date. With this it assumes the standard "00:00:00.000" for the time. Try: SELECT * FROM tabela WHERE data_prova >= '2020-03-01 00:00:00.000' AND…
-
1
votes1
answer55
viewsA: Cursor does not update Level (SQL)
Good morning Lucas. First of all I ask you to always give as much code information as possible formatted as code (like creating the tables and entering the tables [which were in the image]) I had to…
-
0
votes1
answer125
viewsA: Return records according to percentage in sql server
Follows solution: select idfinanciamento ,count(IDPARCELAS) ,count(data_pagamento) ,count(data_pagamento)*100/count(IDPARCELAS) as percentual_pago from parcelas where idfinanciamento in (select…
-
0
votes1
answer51
viewsA: Bring result in a row to Join between tables with 1:N relationship
You should use PIVOT to turn rows into columns:https://www.devmedia.com.br/pivot-no-sql-server-invertendo-linhas-e-colunas-em-um-exemplo-real/28318…