Forum Discussion
How to Display 1 data from Duplicate Data using List ?
Hy Friends, I have problem with my Query I want to display only 1 when it show duplicate Here's my code: SELECT OBS_ParRef, OBSAT_ParRef, OBS_ParRef->MRADM_ADM_DR->PAADM_RowID, OBS_ParRef->...
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.
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