bigfella's recent timeline updates
bigfella

bigfella

V2EX 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
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 )
Jun 13, 2015
Replied to a topic by en3073 Swift swift 语言 关于延时的问题求助
sleep不是毫秒吗?
About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Solana   ·   909 Online   Highest 6679   ·     Select Language
创意工作者们的社区
World is powered by solitude
VERSION: 3.9.8.5 · 20ms · UTC 21:02 · PVG 05:02 · LAX 14:02 · JFK 17:02
♥ Do have faith in what you're doing.