sql过滤重复数据 用SQL语句怎么过滤重复数据

sql过滤重复数据 select distinct b.id，b.names，b.series，b.prize from(select names，series，max(prize)as prize from tb2 group by na...