只显示 mysql 查询的最高结果? [英] Display only top result from mysql query?

问题描述

如何仅显示此查询的最高/最大百分比?

How can I display only the top/largest percentage from this query?

select round((count(*)*100)/(select count(*) from test),1) as percent from test group by field1 order by percent desc

例如这是从查询中收到的数据:

For example this is data received from the query:

我希望在此查询的 HTML 页面上显示的是:

What I want displayed on an HTML page from this query is this:

推荐答案

MySQL 限制！

select round((count(*)*100)/(select count(*) from test),1) as percent from test group by field1 order by percent desc LIMIT 1;

这篇关于只显示 mysql 查询的最高结果?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！