这样的情况怎么能做到?(帮忙看下)
表如下(举例):
-----------------------------------
datetime varchar
-----------------------------------
2007-05-23 08:10:10 A
-----------------------------------
2007-05-23 08:11:20 B
-----------------------------------
2007-05-23 08:14:10 C
-----------------------------------
2007-05-23 08:14:30 D
-----------------------------------
2007-05-23 08:15:40 E
-----------------------------------
按datatime字段排序後,相邻两条记录的datatime字段的间隔不超过2分钟的,合并到一条记录里面去,varchar字段相连接,上面例子结果如下:
-----------------------------------
datetime—HB varchar-HB
-----------------------------------
2007-05-23 08:10:10 A,B
-----------------------------------
2007-05-23 08:14:10 C,D,E
-----------------------------------
这样的情况怎么做?有什么解决办法没有?