Posts by Brothers Info • 46 points
2 posts
-
1
votes1
answer63
viewsQ: How to get all the sums of 'SUM'
Good evening everyone, I would like to sum up with the 3 (SUM CASE) below. SELECT SUM(CASE WHEN (a==b 2 THEN 1 ELSE 0 END) AS qtdDba, SUM(CASE WHEN (a==b 5 THEN 1 ELSE 0 END) AS qtdDev, SUM(CASE…
-
2
votes1
answer944
viewsA: Java: find files in directory
In the first return already ok, you just need to iterate on the vector of File[] and take the values, as I did below. import java.io.File; import java.io.FilenameFilter; import java.nio.file.Path;…