why id minus id is wrong


  • 0
    Z

    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.