[Solved] Making a query with a single row out

Question

You can do conditional aggregation :

select id,
       sum(case when type="x" and location = 'L' then amount else 0 end) as sumofXandL,
       . . . 
from table t
group by id;

Accepted Answer

You can do conditional aggregation :

select id,
       sum(case when type="x" and location = 'L' then amount else 0 end) as sumofXandL,
       . . . 
from table t
group by id;