why id minus id is wrong

  • 0

    Hi all, why id minus id is wrong?

    select w1.Id from weather w1, weather w2
    where w1.id-w2.id=1 and w1.temperature>w2.temperature;

    The output is [2][4].But if submitted, it's wrong.

Log in to reply

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