SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

XMLagg and rownum?

531871Jun 15 2009 — edited Jun 15 2009

Hi

I have a developer here who needs to be able to just take ie max 2 rows pr. aggregate in this look-alike code

SELECT XMLElement("Department", XMLAttributes(deptno AS "deptno"), 
                  XMLAgg(XMLElement("Employee", e.ename)))
   AS "Dept_list"
   FROM scott.emp e
   GROUP BY e.deptno;

Can you give me a hint?

regards
Mette

This post has been answered by MichaelS on Jun 15 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 13 2009

Added on Jun 15 2009

4 comments

677 views