SELECT *, tid AS aaa, ( SELECT uid FROM record WHERE tid = aaa AND win = 1 ORDER BY `value` DESC LIMIT 1 ) AS other_uid FROM `record`
查出同一局玩战绩 是谁赢了, 用tid当子查询条件 去筛选(小问题未知,不能直接用字段tid去当条件,要起别名aaa才能去当条件)
SELECT *, tid AS aaa, ( SELECT uid FROM record WHERE tid = aaa AND win = 1 ORDER BY `value` DESC LIMIT 1 ) AS other_uid FROM `record`
查出同一局玩战绩 是谁赢了, 用tid当子查询条件 去筛选(小问题未知,不能直接用字段tid去当条件,要起别名aaa才能去当条件)