mysql> select
sprice, bprice, how_many_times,rid,dtime,msg,
(select buycount from offer where id=offerhis.groupid) buycount,
(select username from t_users where userid=offerhis.sid) sellername ,
(select username from t_users where userid=offerhis.bid) buyername
from offerhis where groupid=1 and id!=(select id from offerhis where how_many_times=(select max(how_many_times) from offerhis where groupid=1)) order by id desc;
1242 - Subquery returns more than 1 row
MySQL报错Subquery returns more than 1 row 说明子查询返回了多行无法作为条件判断