Three fields
The name address time
Li 1 2010/01/01 00:00:00
Li 2 2010/01/01 00:10:00
Wang 1 2010/01/01 00:00:00
Li 1 2010/01/01 00:05:00
Wang 2 2010/01/01 00:05:00
Wang 1 2010/01/01 00:20:00
.
Requirements:
According to the grouping name and ensure that is carried out in accordance with the time sequence of
{{li, 1201 0/01/01 00:00:00}, {1201 0/01/01 00:05:00}, {2201 0/01/01 00:10:00}}
{wang, 1201 0/01/{01 00:00:00}, {2201 0/01/01 00:05:00}, {1201 0/01/01 00:20:00}}
.
And then calculate the corresponding value
{1 - & gt; 2300 s}
{2 - & gt; 1900 s}
.
CodePudding user response:
Has been resolved aggregate