Posts by Allisson Pereira • 1 point
2 posts
-
0
votes2
answers1081
viewsA: Run SELECT within a CASE
From what I understand you want to retrieve the customer’s name. The above answers already give you a path to what you need. Anyway I’ll just add a possibility id_cliente be an index in its…
-
0
votes2
answers242
viewsA: How to add several decodes in the same line?
Run the query below: select numero_guia, sum(mat) mat, sum(tma) tma, sum(hos) hos, sum(tme) tme, sum(med) med from ( select itg.gui_numero numero_guia, sum(case when itg.pro_tipo_procedimento =…
oracleanswered Allisson Pereira 1