1.统计各类故障名及其发生次数,按降序排列,然后取前10条
select * from(select FAILURENAME,count(*) from crh2_ldr_driver_full group by FAILURENAME order by count(*) desc) where rownum<10;
1.统计各类故障名及其发生次数,按降序排列,然后取前10条
select * from(select FAILURENAME,count(*) from crh2_ldr_driver_full group by FAILURENAME order by count(*) desc) where rownum<10;