代码之家 › 专栏 › 技术社区 › Himal Bissessar

mysql-基于另一组列(文本)计算列(2列带数字)

calculation multiple-columns mysql

Himal Bissessar · 技术社区 · 7 年前

您好,我想查找以下内容的查询,我正在尝试计算两列之间的数据,但基于另一列,该列需要是选定的具有相同值的组

未过滤

开始时间\uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu

12:

10: 59:00.3 \uuuuuuuuuuuuuuuu11:03:03.3 \uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu2.2.2

19: 59:00.3 \uuuuuuuuuuuuuuu20:02:03.3 \uuuuuuuuuuuuuuuuuuuuuuuuuuu1.1.1

已筛选

12:

19: 59:00.3 \uuuuuuuuuuuuuuu20:02:03.3 \uuuuuuuuuuuuuuuuuuuuuuuuuuu1.1.1

如果您看到上表,我只想要所选的IP,即1.1.1.1,然后从那里计算该出口IP从开始时间到断开连接时间的总持续时间。

所以第3列有多个值,但是我需要选择相同的值,然后根据第3列计算第1列和第2列的总和。

如果您有什么想法,请告诉我,因为我尝试了多个查询,但无法得到正确的查询

1 回复 | 直到 7 年前

Emad Elpurgy 7 年前

计算到次之间的差值。可以使用time\u to\u sec将每个时间值转换为秒从结束时间中减去开始时间,得到以秒为单位的时间段。您可以使用SEC\u to\u time将其转换回时间格式实例

select
column3,
SEC_TO_TIME(sum(TIME_TO_SEC(column2) - TIME_TO_SEC(column1))
from 
table 
group by column3

推荐文章

Lee · 当有这么多列时,使用R更改列的特定值

2 年前

D_K · R获取新表

2 年前

Duerna · 将3列一组的多列表格重塑为3列表格[重复]

7 年前

Monica Olvera · 如何按非字母顺序排列pandas数据框中的列,并合并matplotlib表的单元格?

7 年前

TylerNG · 在python中连接/组合类似列

7 年前

Yogita Aher · 如何使用pyspark在下面的代码中传递数组(多列)

7 年前

frank · 如何基于sas中的特定列合并2个表

7 年前

bapors · 比较不同文件的多列,如果存在匹配项,则从文件中追加一列

7 年前

beta · 获取pandas数据帧的唯一列对

7 年前

Satrya Cahya · 如何通过一次保存创建多个foreach?

7 年前