lyongq04
- 浏览: 74506 次
- 性别:
- 来自: 广州
-
最新评论
文章列表
SELECT * FROM (
SELECT t.*,row_number() over(ORDER BY n_count DESC) r
FROM t_51xit t
ORDER BY t.n_count DESC
) t
WHERE r BETWEEN 4 AND 6
当查询大表时，特别是当查询结果再写查询语句时，这种写法比下面这种快n倍
SELECT * FROM (
SELECT t.*
FROM t_51xit t
ORDER BY t.n_count DESC
) t
WHERE rumrow between 4 and 6