Duplicate entries in database table

DELETE 
    FROM
    employee
WHERE
    id IN(
    SELECT
        id
    FROM
        (
        SELECT
            id,
            RANK() OVER(
            PARTITION BY firstname,
            middlename,
            lastname
        ORDER BY
            id
        ) my_rank
    FROM
        employee) AS c
        WHERE
            c.my_rank > 1
    );

you can use this MySQL code to delete the duplicate row in my employee table I have 4 columns id(PrimaryKey),firstname,middlename,lastname. Above mention query will delete all the duplicate rows but will keep one entry of each unique row.

Note this query can partition on the basis of one column or multiple columns or all the columns depending on your requirement change the table name and column names used in the partition. if you want to remove all the duplicates then no need to apply where clause c.my_rank>1

DELETE 
    FROM
    employee
WHERE
    id IN(
    SELECT
        id
    FROM
        (
        SELECT
            id,
            RANK() OVER(
            PARTITION BY firstname,
            middlename,
            lastname
        ORDER BY
            id
        ) my_rank
    FROM
        employee) AS c
        WHERE
            c.my_rank > 1
    );

you can use this MySQL code to delete the duplicate row in my employee table I have 4 columns id(PrimaryKey),firstname,middlename,lastname. Above mention query will delete all the duplicate rows but will keep one entry of each unique row.

Note this query can partition on the basis of one column or multiple columns or all the columns depending on your requirement change the table name and column names used in the partition. if you want to remove all the duplicates then no need to apply where clause c.my_rank>1

Hi Praful, thanks for ur reply. Where in Appian do i use this SQL query?

You can use this query in stored procedure which can be triggered from the process model.