Posts by devin • 109 points
2 posts
-
0
votes1
answer675
viewsQ: Division of tables with Count and Sum
I am preparing a query where I have some sums and counts and, in some parts, I need to make a division in a table that I have added or made the count, for example: COUNT(M.ID_MAILING), SUM(CASE WHEN…
-
9
votes3
answers3392
viewsQ: _ (underline) in consultation with LIKE
I’m making a query where I need to return all information from a given table, which contains "_R_" in the nomenclature. However, when using WHERE NM_CAMPAIGN LIKE '%_R_%' he returns me to other…