sql分页

baobaodqh

于 2018-08-13 18:35:00 发布

阅读量76

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/dangqinghua/article/details/84966478

 1 A.
 2 
 3 --SELECT TOP 15 *  FROM Customer  
 4  --   WHERE CustomerID NOT IN(SELECT TOP (15*(2-1)) CustomerID FROM Customer 
 5  --   ORDER BY CustomerID)
 6     --   ORDER BY CustomerID
 7 
 8  
 9 
10 B.
11         --select top 15 * from Customer where CustomerID not in
12         --    (select top (15 *(10-1)) 
13         --       CustomerID from Customer 
14         --       order by CustomerID)
15         --       order by CustomerID
16 
17 收藏于 2011-02-09