Ask you a question, mysql, assuming that there are three fields, phone number, call time, make a phone call time, how to find out each mobile phone number for each call two intervals of the longest time,
How long is the longest time interval between

CodePudding user response:

Set the line number, subqueries, get the next phone time,
The call time and the next call the difference of time, and then press number minutes, take the maximum value,