mysql排名
select id, topic_id, user_id, comment_time, birthday,rank from( select @rownum:= @rownum+ 1 AS rownum, IF(@x= ou.id, @rank:= @rank+ 1, @rank:= 1) rank, @x:= ou.id, id, topic_id, user_id, comment_time, birthday from( SELECT s.id id, s.topic_id topic_id, s.user_id user_id, s.create_time comment_time, vr.birthday FROM `tb_test` s LEFT JOIN tb_test1 ucr ON s.user_id= ucr.user_id LEFT JOIN tb_test2 vr ON ucr.v_child_id= vr.id WHERE s.topic_id> 0 AND DATE_FORMAT(s.create_time, '%Y-%m-%d')>= '2019-01-01' AND DATE_FORMAT(s.create_time, '%Y-%m-%d')<= '2019-07-31') ou,( SELECT @rownum:= 0, @rank:= 0) init ORDER BY id,birthday asc ) result where topic_id=38 and id in (1096139,1096536)