Sql去重复查询

select *
from (
  select *,
    row_number() over (partition by Code order by code desc ) as seq
  from GNS_Goods
 
) as t where seq=1

Sql去重复查询

标签：