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)