Thursday, 12 September 2013

how to display individual salary and sum of salary in the same query using oracle?

how to display individual salary and sum of salary in the same query using
oracle?

pemp table fields- empno,empname,deptno,sal dept table fields-
deptno,deptname/p pResult:/p pempname,deptname,sal/p pExpected Answer./p
p1.group the sal dept wise and display individual salary/p p2.At the end
of each dept display sum of dept salary./p pHi any one plz shed some light
on this./p

No comments:

Post a Comment