Skip to content
Advertisement

Get data based on condition in oracle sql

My table

Want I want

I tried to use CASE but don’t know the usage

Advertisement

Answer

CASE yes; not with COUNT but with SUM:

User contributions licensed under: CC BY-SA
10 People found this is helpful
Advertisement