[MySQL] -- row_number功能实现

1. 栗子：

SELECT username, password, age, row_number() over(partition by username order by age desc) as rn

FROM tb_user

WHERE rn = 1

2. 实现：

SELECT username, password, age

FROM (
  SELECT @rowno:=@rowno+1 AS rowno, username, password, age
  FROM tb_user, (SELECT @rowno:=0) t
  ORDER BY age DESC
) AS tmp

GROUP BY username