ÇósqlÓï¾äÎÊÌâ

±íTemp½á¹¹ÈçÏ£º
Name  Grade  SNum
ÕÅÈý  B    1000
ÀîËÄ  A    1004
ÍõÎå  B    1001

Ïëͨ¹ýÔÚÊÓͼÖвåÈëÒ»¸öAutoIDÁÐ×÷ΪÐòºÅ£¬ÏÈ°´Grade·Ö×飬ÐòºÅ×Ô¶¯µü¼Ó¡£ÊÓͼvw_TempЧ¹ûÈçÏÂ:
AutoID Name Grade SNum
1      ÀîËÄ A    1004
2      ÕÅÈý B    1000
3      ÍõÎå B    1001
Ó¦¸ÃÈçºÎʵÏÖ£¿

SELECT TOP 100 PERCENT
          (SELECT SUM(1)
        from Temp
        WHERE SNum <= A.SNum) AS AutoID, A.*
from dbo.Temp A
ORDER BY AutoID

---

SQL code:
select row_number() over (order by SNum desc) as AutoID,*
from Temp

---

select row_number() over (order by grade ) as AutoID,*
from Temp

---

SQL code:
1> select * from Temp
2> go
Name |Grade|SNum
----------|-----|-----------
ÕÅÈý |B | 1000
ÀîËÄ |A | 1004
ÍõÎå |B | 1001

(3 rows affected)
1> select row_number() over (order by SNum desc) as AutoID,*
2> from Temp
3> go
Auto