bigfella's recent timeline updates bigfella's recent timeline updates |
bigfellaV2EX member #121789, joined on 2015-06-11 15:21:44 +08:00 |
bigfella's recent replies
Jun 13, 2015 Replied to a topic by xuyl › MySQL › 简单的 sql 查询问题，求教 |
@bin456789 摁~ 没想到， 改了下， 加了性别的条件，应该差不错吧
select * from (select t.sex, max(t.score) as score from score t group by sex) aa, score bb where bb.sex = aa.sex and bb.score = aa.score
select * from (select t.sex, max(t.score) as score from score t group by sex) aa, score bb where bb.sex = aa.sex and bb.score = aa.score
Jun 13, 2015 Replied to a topic by xuyl › MySQL › 简单的 sql 查询问题，求教 |
子查询可行~ 笨方法
select name, sex, score from Score where score in (select max(score) from Score group by sex )
select name, sex, score from Score where score in (select max(score) from Score group by sex )
Jun 13, 2015 Replied to a topic by en3073 › Swift › swift 语言 关于延时的问题求助 |
sleep不是毫秒吗?
Select Language