Hi @Aishwarya Patil

You can use "Distinct" keyword in your Query to remove Duplicate values.

Thanks

karnika

Hi Aishwarya Patil,

Good Day!!

Please Create a Structure and use the structure to select the values from the table (your output aggregate and the select statement of your query has a mismatch).

Also you have missed a , before the count(*) in the above SQL, 

if More clarification are needed please share OML.

FYI - 
Query I have used 

Output of the above Query - 

Structure I have created 

Thanks,
Vignesh Prakash.

Hi Aishwarya,

You can please refer below discussion for remove duplicate record.

https://www.outsystems.com/forums/discussion/79807/duplicate-data/

thanks

CV

Hi,

please  create structure for those column (Employee table column )

and remove Execute Line 5.

Thanks,

Ramesh

SELECT    EmployeeID,    EmployeeName,    EmployeeEmail,    COUNT(*) OVER (PARTITION BY EmployeeName, EmployeeEmail) AS DuplicateCount FROM Employee HAVING COUNT(*) OVER (PARTITION BY EmployeeName, EmployeeEmail) > 1 ORDER BY EmployeeName, EmployeeEmail; 

• SELECT clause: Selects the EmployeeID, EmployeeName, EmployeeEmail, and a count of duplicates.
• COUNT(*) OVER (PARTITION BY ...): Calculates the number of occurrences of each combination of EmployeeName and EmployeeEmail.
• HAVING COUNT(*) OVER (PARTITION BY ...) > 1: Filters the results to show only those rows where the count is greater than 1, indicating duplicates.
• ORDER BY: Orders the results for easier reading and analysis

Hi Aishwarya Patil,

First all you have to identify id`s of duplicate records and then you have to pass those id`s to delete sql statement in sql.

Regards

Shashi Kant Shukla