Oracle中的SQL如下(改造前):
select username,PARTITION BY age order by age desc uuid
from
( select uuid ,username ,`password` ,age from `user` ) b
GROUP BY uuid asc;
(网上copy的代码,有误,但我们关注的重点是关键字改造替换后的区别!)
MySQL中的SQL如下(改造后):
select username,SUBSTRING_INDEX( GROUP_CONCAT(age order by age desc) ,‘,‘,1) uuid from ( select uuid ,username ,`password` ,age from `user` )b GROUP BY uuid asc;
mysql没有partition by关键字,怎么实现分组取第一行数据?用MySQL的SUBSTRING_INDEX解决!
原文:https://www.cnblogs.com/4AMLJW/p/SUBSTRING_INDEX202003171132.html
如果您也喜欢它,动动您的小指点个赞吧