Home 2018 March SQL Puzzle: SQL Advance Query – Get the DISTINCT String data after CONCAT

SQL Puzzle: SQL Advance Query – Get the DISTINCT String data after CONCAT

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

Check the below input data and expected output and get the list of distinct concat string values.

Input Data:

Expected Output:

Create a table with sample data:

Solution using XML PATH:

Please try the different solution for this puzzle and share it via comment...

Anvesh Patel
SQL Puzzle: SQL Advance Query - Concat the String records without using STUFF functionSQL Puzzle: SQL Advance Query - How to get the Name of Month
Comments: 5
  1. Sandeep
    July 18, 2018 at 7:35 am

    SELECT CAST(Abs(rand()*100) AS INT)%50

    ReplyCancel
  2. Ankush
    September 14, 2018 at 8:07 am

    Select LISTAGG(strname, ‘,’) WITHIN GROUP (ORDER BY strname)
    from
    (Select distinct strname from table)foo

    ReplyCancel
  3. Dpan
    April 16, 2019 at 4:44 am

    SELECT Distinct(strname) as strname into #tbl_strings3 from #tbl_strings

    select ROW_NUMBER() over (Order by strname) as rownumber, strname into #tbl_strings4 from #tbl_strings3
    Declare @i int,@str nvarchar(max) ; set @i=1;set @str=”;
    while (@i<=4)
    begin
    select @str=Concat(@str,strname,',') from #tbl_strings4 where rownumber=@i
    print @str;
    set @i=@i+1;
    end

    ReplyCancel
  4. HIC
    April 28, 2019 at 8:05 am

    declare
    s varchar2(255) := ”;
    begin
    for c in (select distinct strname from tbl_strings)
    loop
    s := s || c.strname || ‘, ‘;
    end loop;

    s := rtrim(s, ‘, ‘);

    dbms_output.put_line(s);
    end;

    ReplyCancel
  5. koustav Modak
    November 2, 2019 at 6:50 am

    select array_to_string(array_agg(replace(replace(result::text,'(‘,”),’)’,”)), ‘,’) rel_name
    from
    (select distinct strname from tbl_strings order by 1)result

    ReplyCancel

Leave a Reply to koustav Modak Cancel reply

CAPTCHA

*

Anvesh Patel
Anvesh Patel

Database Engineer

March 14, 2018 5 Comments SQL Puzzle, , , , , , , , , , , , ,