84669 person learning
152542 person learning
20005 person learning
5487 person learning
7821 person learning
359900 person learning
3350 person learning
180660 person learning
48569 person learning
18603 person learning
40936 person learning
1549 person learning
1183 person learning
32909 person learning
例如:表 user temp ranku1 a 2u1 b 0.5u1 c 3u2 aa 1.7u2 cc 3u3 dd 2我希望拿到u1,b
u2,aa
小伙看你根骨奇佳,潜力无限,来学PHP伐。
Suppose your table name is test:
select a.user, a.temp from test a left join test b on a.user = b.user and a.rank > b.rank where b.rank is NULL;
The one upstairs is the correct answer.
Suppose your table name is test:
The one upstairs is the correct answer.