Sql Query for the specified format!

[WROOS]

SELECT ENO, ENAME, SUM(DECODE(CR_DR,'D',SAL,0) D,
SUM(DECODE(CR_DR,'C',SAL,0) C
FROM SS
GROUP BY ENO, ENAME;