从EF框架运行时,监听到的SQL代码,
分页SQL语句 (其中之一)
select top (5) t2.goodsID,t2.quantity ,t2.rn
from(
select t1 .goodsID ,t1.quantity ,
row_number() over (order by t1.quantity) as rn
from daytodayAccount as t1 )
as t2
where t2.rn>10
从EF框架运行时,监听到的SQL代码,
分页SQL语句 (其中之一)
select top (5) t2.goodsID,t2.quantity ,t2.rn
from(
select t1 .goodsID ,t1.quantity ,
row_number() over (order by t1.quantity) as rn
from daytodayAccount as t1 )
as t2
where t2.rn>10