创建数据表语句
![](https://i-blog.csdnimg.cn/blog_migrate/fb339b0486e78d3f49d5328227bf6e14.png)
![](https://i-blog.csdnimg.cn/blog_migrate/9a60dbdc993e0b604d08f375538df52e.png)
数据表数据
![](https://i-blog.csdnimg.cn/blog_migrate/44dc82a32240267d7bd557e13f015d4b.png)
对上述数据进行TopN排名
![](https://i-blog.csdnimg.cn/blog_migrate/5c8b1805fe9c1376954539e80d6515cd.png)
select severity,sum(count) as sum from widgt_23 where insertTstamp>='2016-12-05 17:40:00' and insertTstamp<='2016-12-05 18:00:00' group by binary(severity) order by sum desc limit 10;
获取趋势图数据
![](https://i-blog.csdnimg.cn/blog_migrate/9394b9378bc72fc861eafa22f3d108ae.png)
select * from widgt_23 where insertTstamp>='2016-12-05 17:40:00' and insertTstamp<='2016-12-05 18:00:00' and severity=binary('Info') ;