如何用mysql实现提取相同字段 并相邻字段做差
表结构如下:
time srcip dstip port
2012-04-26 15:32:15192.168.90.13192.168.90.1133460
2012-04-26 15:32:15192.168.90.13192.168.90.1133460
2012-04-26 15:32:15192.168.90.13192.168.90.1133460
2012-04-26 15:32:26192.168.19.200192.168.90.280
2012-04-26 15:32:43192.168.19.200192.168.90.33306
2012-04-26 15:33:15192.168.90.1361.235.71.1003460
2012-04-26 15:33:18192.168.90.1361.235.71.1003460
2012-04-26 15:33:24192.168.90.1361.235.71.1003460
2012-04-26 15:33:26192.168.19.200192.168.90.280
1、将srcip dstip port三项都相同行归到一起
2、将1中的行 相邻的时间做差
3、统计差值中 出现次数最多的差值的百分比
如何用mysql实现啊,请大牛指点下
[解决办法]
贴建表及插入记录的SQL,及要求结果出来看看
[解决办法]
1
select distinct time,srcip,dstip,port
from tb