Let me first off thank you for helping me.
The problem is as stated:
I’m trying to create a report from the EMP and SALGRADE tables. The report counts total employees by department and counts the department’s employee by salary grade.
The result is suppose to look like this:
Total Grade 1 Grade 2 Grade 3 Grade 4 Grade 5
—- —– —— —— —— ——- 3 1 1 1
5 2 3
6 1 2 2 1
Thanks again for all who can help me code this in Oracle. Before the the Total it has the “DNAME”
Henry
