Gemini vs powerphotos2/19/2023 ![]() Some examples of code (real data can be in millions)Ĭreate table test_dup_del (num number (10), dup_val varchar2 (100)) ![]() I have an obligation to remove duplicates of string separated by commas: How to remove duplicates from comma separated string What exactly have you tried? (However, it is probably more effective to get the unique results immediately the bat, rather than producing more than you want and then by doing something more to get rid of the duplicates). See for other ways to string aggregation, including a user-defined aggregate function and SYS_CONNECT_BY_PATH. LISTAGG isn't the only way to get the desired results. THE Group (ORDER BY ptpos_list) in the form of recommendations This is a feature annoying LISTAGG - you cannot use DIFFERENT with her.Ī workaround is to to a separate GROUP BY, or SELECT DISTINCT simply get the unique values, then call LISTAGG on these unique results, like this: It seems like it was replaced by part_type(s)/position(s):20/2 from content: 100 It seems like it was replaced by part_type(s)/position(s):10/1 from content: 100 You need to remove from a call LISTAGG dups. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |