Mysql 中因为没有ROWNUM伪列、 那么想要排名、 我们就先要搞出一列伪列、 用作排名
伪列为分组排名的核心内容
SELECT
(@r :=@r + 1) AS rank
FROM (SELECT @r := 0) r
;
举个例子:
创建临时表插入测试数据
CREATE TEMPORARY TABLE tm_test (num int , createdat datetime );
INSERT INTO tm_test (num, createdat) VALUES (1, '2018/12/28 21:41:20');
INSERT INTO tm_test (num, createdat) VALUES (1, '2018/12/28 21:42:20');
INSERT INTO tm_test (num, createdat) VALUES (1, '2018/12/28 21:42:20');
INSERT INTO tm_test (num, createdat) VALUES (1, '2018/12/28 21