当前位置：Gxlcms > 数据库问题 > Sql去重复查询

Sql去重复查询

时间：2021-07-01 10:21:17 帮助过：3人阅读

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

) as t where seq=1

Sql去重复查询

标签：

人气教程排行