如何从行号获取数据在SQL Server中为5到15 [英] How to Get data from Row no. 5 to 15 in SQL Server
本文介绍了如何从行号获取数据在SQL Server中为5到15的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我在桌子上有20排我想要排第一。 5到15排..所以任何人都可以帮助我...?
谢谢。
解决方案
这可以通过使用来实现CTE(通用表格表达式)以及。
复制并粘贴以下查询并给出相应的列名和表名。
; cte
as
(
选择 row_number() over ( order by col1) as RowNumber,
col1,
col2,
col3
来自 TableName
)
选择 col1 ,col2,col3 来自 cte 其中 RowNumber 5 和 15
:)
是的,你可以
使用OFFSET FETCH条款
SELECT First_Name FROM 员工 ORDER BY 名字OFFSET 5 ROWS FETCH NEXT 15 仅限行;
这将跳过前5行,然后从结果集返回接下来的15行
http://technet.microsoft。 com / en-us / library / gg699618.aspx [ ^ ]
SELECT * FROM
( SELECT ROW_NUMBER() OVER ( ORDER BY col1) as rn, col2,col3,col4
FROM TL_ATM_STATUS)
其中 rn 5 和 15
I Have 20 Row in A Table And I want To get row no. 5 to 15 row ..So Any One can Help Me...?
Thank you.
解决方案
This can be achieved by using CTE(Common Table Expression) as well.
Copy and paste the below query and give appropriate column names and table name.
;with cte as ( select row_number() over(order by col1) as RowNumber, col1, col2, col3 from TableName ) select col1,col2,col3 from cte where RowNumber between 5 and 15
:)
Yes ,You can
use OFFSET FETCH Clause
SELECT First_Name FROM Employees ORDER BY First Name OFFSET 5 ROWS FETCH NEXT 15 ROWS ONLY;
this will skip the first 5 rows and then return the next 15 rows from the resultset
http://technet.microsoft.com/en-us/library/gg699618.aspx[^]
SELECT * FROM (SELECT ROW_NUMBER() OVER(ORDER BY col1) as rn ,col2,col3,col4 FROM TL_ATM_STATUS ) where rn between 5 and 15;
这篇关于如何从行号获取数据在SQL Server中为5到15的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文