mysql - 我想在一行中获得 3 个 SQL 查询结果
解决方案
使用聚合函数
select col1,col3,min(timestamp1) as timestamp1,
min(timestamp2) as timestamp2,min(timestamp3) as timestamp3
from t group by col1,col3
使用聚合函数
select col1,col3,min(timestamp1) as timestamp1,
min(timestamp2) as timestamp2,min(timestamp3) as timestamp3
from t group by col1,col3