Forum Discussion

olafhelper's avatar
olafhelper
Bronze Contributor
Sep 29, 2023

Re: How to Display 1 data from Duplicate Data using List ?

steve_henry2023 , I can't test your code without having your data.

And what is LIST for a function, it's not a MS SQL Server Transact-SQL function?

Please post table design as DDL, some sample data as DML statement and the expected result.

1 Reply

  • steve_henry2023's avatar
    steve_henry2023
    Copper Contributor
    Sep 29, 2023

    Hy olafhelper 

    Thank you for your help

    but It's funny I think, I just try to put distinct here

    List (Distinct(a)) as No_Urut

    and it works

    But I'm still testing, is there any impact with another query ?

     

    Thank You

    Best Regards,

    Steven Henry

Resources