How can I optimize my query because now its 1172 ms


  • 0
    D

    select t.id from Weather t left join Weather y on date_sub(t.Date,interval +1 day) =y.Date where t.Temperature>y.Temperature ;


Log in to reply
 

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