今天刚刚看到,没有测试性能。 SELECT * FROM (select ROW_NUMBER() Over(order by CreditCardID) as rowNum, * from Sales.CreditCard) as table where rowNum> 0 and rowNum<50 |
|小黑屋|最新主题|手机版|微赢网络技术论坛 ( 苏ICP备08020429号 )
GMT+8, 2024-9-29 21:19 , Processed in 0.172595 second(s), 12 queries , Gzip On, MemCache On.
Powered by Discuz! X3.5
© 2001-2023 Discuz! Team.