获取MAX（字段）LIMIT 1的同一行中的字段值(get field value in the same row where MAX(Field) LIMIT 1)

获取MAX（字段）LIMIT 1的同一行中的字段值(get field value in the same row where MAX(Field) LIMIT 1)

我有一个名为'App'的表

---

ID | Name | Developer | price | downloads 1 | App1 | App Developer | Free | 5

---

我正在使用此代码获得最大下载量

mysql_connect("$host", "$username", "$password") or die(mysql_error()); mysql_select_db("$database") or die(mysql_error()); $mostappdownloaded = mysql_query("SELECT MAX(downloads) as maxdownloads FROM app") or die(mysql_error()); while($infomostdownloadapps = mysql_fetch_array( $mostappdownloaded )) { echo $infomostdownloadapps['maxdownloads']; }

我想从包含最大下载应用程序的行中获取开发人员字段值

任何帮助？

i have a table called 'App' contains

---

ID | Name | Developer | price | downloads 1 | App1 | App Developer | Free | 5

---

i am using this code to get max downloads

mysql_connect("$host", "$username", "$password") or die(mysql_error()); mysql_select_db("$database") or die(mysql_error()); $mostappdownloaded = mysql_query("SELECT MAX(downloads) as maxdownloads FROM app") or die(mysql_error()); while($infomostdownloadapps = mysql_fetch_array( $mostappdownloaded )) { echo $infomostdownloadapps['maxdownloads']; }

i want to get the developer field value from the row that contains max downloaded app

any help ?

最满意答案

尝试使用子查询

SELECT Developer FROM App WHERE downloads = (SELECT MAX(downloads) as maxdownloads FROM app);

有可能有几个记录具有相同的最大下载次数

try this with a subquery

SELECT Developer FROM App WHERE downloads = (SELECT MAX(downloads) as maxdownloads FROM app);

It can be possible that there are several records with the same max numbers of downloads