select
a.host_name hostname,
Round(a.record/10000,2) R1,
Round(b.record/10000,2) R2,
Round(a.record/b.record*100,0) S
FROM
(select
day_no, host_name, sum(record) record
from t_keywords_topic_class_host1
WHERE
day_no='20190716' and data_type='3g'
group by
host_name,day_no,data_type
ORDER BY record desc limit 10)a
left join
(select host_name,sum(record) record
from t_keywords_topic_class_host2
where day_no='20190716' and data_type='3g'
group by day_no,data_type,host_name) b
on a.host_name=b.host_name;mysql版本:5.5.56
查询结果以R1降序:但在线上5.6.14版本查询结果R1,R2,S都是乱序的,为啥啊?
a.host_name hostname,
Round(a.record/10000,2) R1,
Round(b.record/10000,2) R2,
Round(a.record/b.record*100,0) S
FROM
(select
day_no, host_name, sum(record) record
from t_keywords_topic_class_host1
WHERE
day_no='20190716' and data_type='3g'
group by
host_name,day_no,data_type
ORDER BY record desc limit 10)a
left join
(select host_name,sum(record) record
from t_keywords_topic_class_host2
where day_no='20190716' and data_type='3g'
group by day_no,data_type,host_name) b
on a.host_name=b.host_name;mysql版本:5.5.56
查询结果以R1降序:但在线上5.6.14版本查询结果R1,R2,S都是乱序的,为啥啊?
没有设置主键,innnodb 自己生成的主键,可能不一样
所以要按序输出,一定要加order by