武汉天华华中建筑设计有限公司_办公室设计效果图_辽宁网站建设费用_企业所得税怎么算出来的

drop table dw_pvs_d;

create table dw_pvs_d(day string,url string,pvs string);

insert into table dw_pvs_d

select '2013-09-18',a.request,a.request_counts from

(select request as request,count(request) as request_counts from ods_weblog_detail where datestr='2013-09-18' group by request having request is not null) a

order by a.request_counts desc limit 10;

结果如下：