SQLServerѧϰ¼Ç¼

use TestDataBase;go -- ÅÉÉú±í-- µÚ3Ò³£¬Ã¿Ò³5ÌõÊý¾Ýselect * from (select ROW_NUMBER() over(order by stuId) as num, * from Student) as twhere t.num between (3 - 1)