row_number

最新推荐文章于 2024-10-25 15:27:57 发布

付家子弟

最新推荐文章于 2024-10-25 15:27:57 发布

阅读量498

点赞数

本文链接：https://blog.csdn.net/fzw19911206/article/details/8674887

版权

DECLARE @pageindex INT;
DECLARE @pagesize INT;
SET @pageindex=2;
SET @pagesize=3;

--ROW_NUMBER具有通用性，以后就用它
SELECT * FROM
(SELECT ROW_NUMBER() OVER(ORDER BY Id) AS rownumb,* FROM T_News ) A
WHERE (NewsTitle LIKE '%国%' OR NewsContent LIKE '%国%') AND
rownumb>(@pageindex-1)*@pagesize AND rownumb<=@pageindex*@pagesize

GO
DECLARE @pageindex INT;
DECLARE @pagesize INT;
SET @pageindex=2;
SET @pagesize=3;

--ROW_NUMBER具有通用性，以后就用它
SELECT * FROM
(SELECT ROW_NUMBER() OVER(ORDER BY Id) AS rownumb,* FROM T_News WHERE NewsTitle LIKE '%国%' OR NewsContent LIKE '%国%') A
WHERE rownumb>(@pageindex-1)*@pagesize AND rownumb<=@pageindex*@pagesize

SELECT * FROM T_News WHERE Id>0 AND Id<=3

SELECT * FROM
(SELECT ROW_NUMBER() OVER(ORDER BY Id) AS rownumber, NewsTitle,NewsContent,CreateTime FROM T_News
WHERE NewsTitle LIKE '%国%' OR NewsContent LIKE '%国%') A
WHERE A.rownumber>0 AND A.rownumber<=3