|
|
Re: Columns into Rows Thru ORACLE SQL [message #355456 is a reply to message #355455] |
Fri, 24 October 2008 03:05   |
oracle_dev
Messages: 24 Registered: April 2007
|
Junior Member |
|
|
this is my normal sql
SELECT dept_no,dept_name, SUM(NVL(col1,0)) col1,SUM(NVL(col2,0)) col2, SUM(NVL(col3,0)) col3
FROM emp a, dept b
WHERE end_date BETWEEN '' AND ''
AND a.dept_no = b.dept_no
GROUP BY dept_no,dept_name
|
|
|
Re: Columns into Rows Thru ORACLE SQL [message #355458 is a reply to message #355456] |
Fri, 24 October 2008 03:11   |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
And? Does it work?
What output do you get? What output do you want?
What input do you use?
Read the Forum guide for guidelines on how to post a question and how to increase the chances on a useful answer
|
|
|
|
|