Comments for LISTAGG DISTINCT in Oracle Database 19c
GlenM said...I think the ROW_NUMBER() pre-19c solution needs to be partitioned by deptno,ename instead of just ename. If your test data added a Miller to another department I expect your result would only show Miller working in one department.
Correct. Funny that a goofed on that, but did is correctly on the following example with distinct. Thanks for the headsup. :)
The link to this page from this page (https://oracle-base.com/articles/19c/articles-19c) reads: "LISTAGG DISTINCT in Oracle Database 19c - Oracle 19c includes the ability to remove duplicates from the LISTAGG results by including the DEFAULT keyword."
I think you wanted to say DISTINCT there.
You don't allow comments on the source page.
Thanks for the heads-up. That typo is fixed in the article and in the link page.
DO NOT ask technical questions here! They will be deleted!
These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!
If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.