试图选择具有最高时间戳值和最低ID值的20个项目?

| 我正在尝试选择\'TimeStamp \'值最高的20行,并从那20行中选择ID值最低的1行:
$result_last = mysql_query(\"SELECT * FROM (SELECT * FROM Events ORDER BY TimeStamp DESC LIMIT 20) ORDER BY ID ASC LIMIT 1\");
上面的查询不起作用,但对我来说有意义。这个查询有问题吗?     
已邀请:
错误是is1ѭ,的确如此。这应该工作:
$result_last = mysql_query(\"SELECT * FROM (SELECT * FROM Events ORDER BY TimeStamp DESC LIMIT 20) AS T ORDER BY ID ASC LIMIT 1\");
    
尝试这样的事情:
$result_last = mysql_query(\"SELECT * FROM Events WHERE TimeStamp IN(SELECT TimeStamp FROM Events ORDER BY TimeStamp DESC LIMIT 10\") ORDER BY TimeStamp ASC LIMIT 1);
    

要回复问题请先登录注册