select hostname, count(*) as nums ,count(*) /sums,sums
from dns_messages , (select count(*) as sums
from dns_messages where capture_date >= "1991-01-01 00:00:00" and capture_date <= "2020-01-01 00:00:00"
) as dd
where capture_date >= "1991-01-01 00:00:00" and capture_date <= "2020-01-01 00:00:00"
group by hostname
order by nums desc, hostname desc
from dns_messages , (select count(*) as sums
from dns_messages where capture_date >= "1991-01-01 00:00:00" and capture_date <= "2020-01-01 00:00:00"
) as dd
where capture_date >= "1991-01-01 00:00:00" and capture_date <= "2020-01-01 00:00:00"
group by hostname
order by nums desc, hostname desc
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货