Posts by Bruno Fabiano • 23 points
3 posts
-
0
votes2
answers37
viewsQ: How can I apply increase and percentage reduction over unit value
The script below calculates the consumption value for materials and medicines , grouping by patient. select coalesce( sum ( ( (L.QTDE) - coalesce( sum( ( select sum(QTDE) from GECADDEV CD inner join…
-
0
votes1
answer33
viewsQ: Doubt column concatenation
The code below returns a sum per classification. Something like this: Services = type 1 Materials = type 2 the expected result is that there is only one row, and that in this Row I have the value of…
-
-1
votes1
answer33
viewsQ: SUBSELECT - POSSIBILITY OF IMPROVEMENT
I would like some guidance on a query. It is working, but the current script generates a very high reading demand in the bank due to a case comparing a table data, with another through a subselect…