SQL query _ Remove Duplicate

[ravindar.singh (Rav Singh)]

I want to remove duplicate from Column Booking No after sorting. I have done the sorting part but can’t figure out how to delete duplicate.

Thanks in advance

[fernando_zuluaga]

hey

you need to delete those rows in your internal datatable in uipath, or in your database using a query?

regards

[ravindar.singh (Rav Singh)]

in uipath. I am using Execute query activity

[fernando_zuluaga]

Try with this

newDT = yourDT.DefaultView.ToTable(True,"Booking No", "Component Start")

Regards!

[ushu (Usha kiranmai)]

@ravindar.singh Can you let me know the expected output

[arivu96 (Arivazhagan A)]

HI @ravindar.singh ,
The query is correct and returned distinct values. as per the code you have used distinct for both Booking No & Component Star columns.

Let me know the expected output will change in SQL query

Regards,
Arivu

[ravindar.singh (Rav Singh)]

Sorry this didn’t work

[ravindar.singh (Rav Singh)]

Hi @arivu96 - Outcome I want is 1 row from each booking No after sort