如何从表中检索特殊行。其中table只有一个列名。 [英] how to retrieve a particula row from a table. where table have only one column name.
本文介绍了如何从表中检索特殊行。其中table只有一个列名。的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
表只有一个列名。我必须检索一个特定的行号,比如第5个,第6个
解决方案
参考: SQL查询中的数字(Microsoft SQL Server 2000和2005) [ ^ ]
嗨Manish,
试试这个
解决方案1: - Row_Number()函数
缺点:-Row_Number对Column值进行排序,这样你就无法在原始表格中检索该行号的确切值。
解决方案2 : -
声明@tbl(ID int Identity(1,1),ColumnVal varchar(100))
插入@tbl
选择TableName from Table - (你的表有列名)
从@tbl中选择columnVal,其中ID = 5(或6 Wh在你想要的时候);
希望它对你有所帮助。
:)
你好 Manish ,
SELECT * FROM (
SELECT
ROW_NUMBER() OVER (< span class =code-keyword> ORDER BY columnname ASC ) AS rownumber,
columnname
FROM tbl_studreg
) AS foo
WHERE rownumber = 5 或 rownumber = 6
无限期它会起作用:-) :-)
改进的答案
SELECT * FROM (
SELECT
ROW_NUMBER() OVER ( ORDER BY ID ASC ) AS rownumber ,
ID
FROM tablename
) AS foo
WHERE ID = 5
对于ID替换你的条件栏
条件列名称必须是主键
table have only one column name.i have to retrieve a particular row number,like 5th,6th
解决方案
refer : Row Numbers in SQL Query (Microsoft SQL Server 2000 and 2005)[^]
Hi Manish ,
try this
Solution 1:- Row_Number () function
Cons :-Row_Number sort the Column value so that u cant not retrieve exact value at that row number as it is in Original Table .
Solution 2:-
Declare @tbl (ID int Identity(1,1), ColumnVal varchar(100))
Insert into @tbl
Select ColumnName from Table --(your table with Column name )
Select columnVal from @tbl where ID=5 (Or 6 What ever u want);
Hope it helps u lot .
:)
Hi Manish,
SELECT * FROM ( SELECT ROW_NUMBER() OVER (ORDER BY columnname ASC) AS rownumber, columnname FROM tbl_studreg ) AS foo WHERE rownumber =5 or rownumber = 6
DEfinitely it will work :-):-)
Improved Answer
SELECT * FROM ( SELECT ROW_NUMBER() OVER (ORDER BY ID ASC) AS rownumber, ID FROM tablename ) AS foo WHERE ID =5
For "ID" Replace ur condition column
The condition column name must be primary key
这篇关于如何从表中检索特殊行。其中table只有一个列名。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文