想要在数据过滤的时候,月份是当前月份SELECT realAmount,planAmount,planDateFROM .,.where ..planID=..planID and datepart(yyyy,planDate)='2013' and datepart(MM,planDate)='month(now())'
select * from( select row_number() over( sno order by sno asc ) as r ,* from student //将sno添加 伪序 where r <= n*10 )where row_number>=(n-1 )*10;这个n还有row_number是哪来的?能够解释一下吗?