去除重复

[airen12345678]

表
id name size

我要去除重复的name并且留下size数字最大的
？？？？？

[百年树人]

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)

[百年树人]

如果不要显示id

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)

[Mr_Nice]

路过，学习...

[-狙击手-]

select name,max(size) as size from tb group by name

[Zoezs]

select * from tb t where not exists(select 1 from tb where name=t.name and size>t.size)

[airen12345678]

这么快
呵呵
谢谢

[--小F--]

select
  *
from
  tb t
where
  size=(select max(size) from tb where name=t.name)