Why I can't use exists


  • 0
    L

    The query is wrong:

    delete from Person p1 where exists (select 1 from Person p2 where p1.Id > p2.Id and p1.Email = p2.Email)
    

    Runtime Error Message:
    Line 2: SyntaxError: near 'p1 where exists (select 1 from Person p2 where p1.Id > p2.Id and p1.Email = p2.E'
    Last executed input:
    {"headers": {"Person": ["Id"
    "Email"]}
    "rows": {"Person": []}}


Log in to reply
 

Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.