By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
7 rows affected
| XML_F52E2B61-18A1-11d1-B105-00805F49916B |
|---|
| <Root><Node><Id>1</Id><Name>John Smith</Name><Age>20</Age><Gender>Male</Gender></Node><Node><Id>2</Id><Name>Jane Smythe</Name><Age>26</Age><Gender>Female</Gender><Org_Group>Marketing</Org_Group></Node></Root> |
Warning: Null value is eliminated by an aggregate or other SET operation.