select uid,name from (select uid,name from aa union select uid,name from bb) t group by uid order by uid desc LIMIT 10;
image.png
運(yùn)行上面那個(gè)SQL會(huì)報(bào)錯(cuò)，因?yàn)?.7版本之后的MYSQL不在group by里的字段 跟在select會(huì)報(bào)錯(cuò)解決辦法是，用函數(shù) any_value(字段名)
select any_value(name),max(uid)from (select uid,name from aa union select uid,name from bb) t group by uid order by uid desc LIMIT 10;
運(yùn)行上面的SQL 不報(bào)錯(cuò)了
image.png
