Question

关于mysql的问题

(select count(1) from tour.sign_score s,tour.sign_log l where s.uid=l.uid and score >=(select score from tour.sign_score where uid =?)
group by s.uid having max(create_time)>=(select max(create_time) from tour.sign_log where uid = ? group by uid ))reg_ranking,
我是想计算我的积分排名，分数相同的话就用最后签到的时间进行排名，我自己写了个，但是显示是错误的，
sign_score 用户积分表
uid score
sign_log 用户签到表
uid score_value create_time
对groupby 和having不是很熟

Answer 1

select s.*,l.* from sign_score s,sign_log l where s.uid=l.uid order by s.score,l.create_time