php 最后一行,php – 选择最后一行

此查询将为每个用户选择最高分：

select uid, max(`points`)

from members

group by uid

这将选择用户具有最大分数的最大ID：

select uid, max(id)

from members

where (uid, `points`) in (select uid, max(`points`)

from members

group by uid)

group by uid

这是您需要的最终查询：

select members.*

from members

where (uid, id) in (

select uid, max(id)

from members

where (uid, `points`) in (select uid, max(`points`)

from members

group by uid)

group by uid)

这表明：

ID UID POINT DATE TIME

2 2 10 2012-11-29 11:38:12

3 1 10 2012-12-02 05:15:01

6 3 5 2012-12-04 12:18:30

这也会给出相同的结果,看起来更简单：

SELECT s.*

FROM

(SELECT members.*

FROM members

ORDER BY uid, points desc, id desc) s

GROUP BY uid

我认为它会一直有效,但它没有记录！

对最后一个查询的一点解释：MySql允许您通过查询选择组中的非聚合字段.这里我们按照uid进行分组,但是选择所有列：文档说非聚合列的值将是未确定的(它可以是组内的任何值)但实际上MySql只返回第一个遇到的值.由于我们在有序子查询上使用非聚合列应用组,因此第一个遇到的值就是您所需要的.