select *from ( select *, row_number() over (partition by Code order by code desc ) as seq from GNS_Goods ) as t where seq=1
Sql去重复查询
原文：http://www.cnblogs.com/promisehgh/p/4664290.html
