获取MAX(字段)LIMIT 1的同一行中的字段值(get field value in the same row where MAX(Field) LIMIT 1)
ID | Name | Developer | price | downloads 1 | App1 | App Developer | Free | 5
ID | Name | Developer | price | downloads 1 | App1 | App Developer | Free | 5
我有一个名为'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
更多推荐
发布评论