排序后名字相同取第一条的sql文

select top 10 * from(
    select rn=ROW_NUMBER() OVER (PARTITION BY SUBSTRING(c.PRD_SNAME,0,20) Order By c.PRD_MAX_YLD_DE DESC),
    c.PRD_SNAME,c.Inner_Code,c.BANK_NAME,c.PRD_MAX_YLD_DE,SUBSTRING(c.PRD_SNAME,0,20) PRD_SNAME_L
    from Score c
    where c.SELL_END_DATE>='2014-1-28' and c.ENTR_CURNCY_TYPE=1
     ) temp
     where rn=1
ORDER BY temp.PRD_MAX_YLD_DE DESC
保存一下，开窗函数比较好使，得多学习一下