sqlè¯å¥ä¸ï¼å
³èæ¥è¯¢åªååç»çä¸æ¡è®°å½çæ¹æ³å¦ä¸ï¼
select userid,ranking,username from table //æ¥è¯¢å段æuserid username
where userid+ranking in //where æ¡ä»¶å
æ¬userid+ranking inæ¯éåéæ©å
³é®å
(
select userid+max(ranking) from table // maxï¼rankingï¼éæ©rankingåçæ大å¼
group by userid //æ ¹æ®useridåç»
)
以ä¸sqlä¸ï¼å
å±selectæ¥åºäºæ大çrankingï¼æ ¹æ®useridåç»ï¼å¤å±æ¥è¯¢ä¸éæ©userid+rankingã