8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

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.


Tim... said...


Correct. Funny that a goofed on that, but did is correctly on the following example with distinct. Thanks for the headsup. :)



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.