Posts by Rodrigo Sousa • 11 points
2 posts
-
0
votes1
answer69
viewsQ: MYSQL returns OK
Good evening friends, Can anyone tell me why the query below returns OK? SELECT Count(*) as Dias_uteis FROM Owner.dias_uteis d WHERE d.data_util BETWEEN (select ts.creatión from Owner.tabela ts…
-
0
votes1
answer22
viewsQ: Automation of code
Using a DB2 database I need to automate a query and currently have the following scenario: SELECT * FROM tabela WHERE DATA1 < '2020-06-01' AND DATA2 >= '2020-05-01' How to make date conditions…