22,199
社区成员
发帖
与我相关
我的任务
分享
select
*
from
tb t
where
size=(select max(size) from tb where name=t.name)
select * from tb t where not exists(select 1 from tb where name=t.name and size>t.size)
select * from tb t
where not exists(select 1 from tb where name=t.name and size>t.size)
select name,max(size) as size from tb group by name
select * from tb t
where not exists(select 1 from tb where name=t.name and size>t.size)
select *
from tb t
where not exists(select 1 from tb where name=t.name and size>t.size)