Sql ¸ù¾ÝÃû³ÆÌÞ³ýÖظ´Êý¾Ý¡¢¸ù¾Ýid·µ»Ø×îеÄ

select *
  from (
        select soft.NETMODEL,
                soft.softname,
                soft.softid,
                soft.SOFTVER,
                soft.createdate,
                row_number() over(partition by softname order by softId desc) indexId
          from ZTEspt_Soft_File soft
         where soft.softkind = 7)
 where indexId = 1;
Òª½â¾öµÄÎÊÌâ
Òѽâ¾öµÄЧ¹û