-
Notifications
You must be signed in to change notification settings - Fork 22
sql 分组取最大值
L edited this page Sep 3, 2020
·
1 revision
根据group by进行分组,取每组某字段最大值的那条记录
下面的sql根据TABLE_META_ID group by分组,然后取每组VERSION字段最大的一条记录
select e.*
from edition e
inner join
(select e2.TABLE_META_ID,max(e2.VERSION) as VERSION
from edition e2
group by e2.TABLE_META_ID)b
on e.TABLE_META_ID=b.TABLE_META_ID and e.VERSION=b.VERSION