PersonID INTime IsIN
1 2016-09-07 08:12:00 1
1 2016-09-07 17:42:00 0
1 2016-09-08 09:11:00 1
1 2016-09-08 18:02:00 0
1 2016-09-08 19:12:00 0
想要的结果为:
PersonID date mintime maxtime
1 2016-09-07 2016-09-07 08:12:00 2016-09-07 17:42:00
1 2016-09-08 2016-09-08 09:11:00 2016-09-08 19:12:00
把每人每天的最大值和最小值取出来