Breaking News: Grepper is joining You.com. Read the official announcement!
Check it out

DELETE c1 FROM tablename c1 INNER JOIN tablename c2 WHERE c1.id > c2.id AND c1.unique_field = c2.unique_field;

Add Answer
vicky chary answered on May 20, 2022 Popularity 1/10 Helpfulness 1/10

Contents

  • answer DELETE c1 FROM tablename c1 INNER JOIN tablename c2 WHERE c1.id > c2.id AND c1.unique_field = c2.unique_field;

    • More Related Answers


    DELETE c1 FROM tablename c1 INNER JOIN tablename c2 WHERE c1.id > c2.id AND c1.unique_field = c2.unique_field;

    Comment
    0
    Popularity 1/10 Helpfulness 1/10 Language python
    Source: catchconsole.com
    Tags: inner-join python tablename where
    Link to this answer
    Share Copy Link
    vicky chary
    Contributed on May 20 2022
    vicky chary
    0 Answers  Avg Quality 2/10

    X

    Continue with Google

    By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.
    X
    Grepper Account Login Required

    Oops, You will need to install Grepper and log-in to perform this action.