选择语句如何选择特定行 [英] Select Statement how to select a particular row

问题描述

我在sql表中有行，我需要单独接第5行怎么办?

解决方案

使用ROW_NUMBER()

我举一个例子

  WITH  [EMPLOYEE ORDERED  BY  ROWID] 选择 ROW_NUMBER() OVER (> ORDER   BY  EMPID  ASC ) AS  ROWID，*  FROM 雇员)
选择 *  FROM  [员工订单> BY  ROWID ] 位置 ROWID = 5 

上面的查询将仅返回表的第5行.

首先，请阅读我对问题的评论并对解决方案的评论. 1.

其次，阅读它: http://stackoverflow.com/questions/10387386/equivalent-of -limit-in-t-sql [ ^ ]

  WITH 成员 AS 
(
     SELECT  M_NAME，M_POSTS，M_LASTPOSTDATE，M_LASTHEREDATE，M_DATE，M_COUNTRY，
            ROW_NUMBER() OVER ( ORDER   BY  M_POSTS  DESC ) AS 行号
     FROM  dbo.FORUM_MEMBERS
)
 SELECT 行号，M_NAME，M_POSTS，M_LASTPOSTDATE，M_LASTHEREDATE，M_DATE，M_COUNTRY
 FROM 成员
位置 RowNumber  BETWEEN   1   AND   20 
订单  BY  RowNumber  ASC ;  

以及: http://msdn.microsoft.com/en-us/library/ms175972.aspx [ ^ ] 



我认为，根据您的条件，您可以使用类似这样的方法来返回实用的行:

  SELECT  *
 FROM 您的表格
位置 FieldID =  @ ID  
 



有关更多信息，请访问: http://msdn.microsoft.com/en-us/library/ms188047.aspx [ ^ ] 



您可以使用TOP子句执行以下操作:

  SELECT   TOP ( 1 )*
 FROM ( SELECT   TOP ( 5 )*  FROM  YourTable  ORDER   DESC ) http://msdn.microsoft.com/en-us/library/ms189463.aspx [ ^ ] 

 从产品中选择 MAX(model) 其中在中建模(>选择 顶部  5 模型来自产品通过模型))； 

I have rows in sql table i need to pick up 5th row alone how can i?

解决方案

Use ROW_NUMBER()

I am giving an example

WITH [EMPLOYEE ORDERED BY ROWID] AS
(SELECT ROW_NUMBER() OVER (ORDER BY EMPID ASC) AS ROWID, * FROM EMPLOYEE)
SELECT * FROM [EMPLOYEE ORDERED BY ROWID] WHERE ROWID =5

The above query will return only 5th row of the table.

First of all, read my comment to the question and comment to the solution no. 1.

Secondly, read it: http://stackoverflow.com/questions/10387386/equivalent-of-limit-in-t-sql[^]

WITH Members  AS
(
    SELECT  M_NAME, M_POSTS, M_LASTPOSTDATE, M_LASTHEREDATE, M_DATE, M_COUNTRY,
            ROW_NUMBER() OVER (ORDER BY M_POSTS DESC) AS RowNumber
    FROM    dbo.FORUM_MEMBERS
)
SELECT  RowNumber, M_NAME, M_POSTS, M_LASTPOSTDATE, M_LASTHEREDATE, M_DATE, M_COUNTRY
FROM    Members
WHERE   RowNumber BETWEEN 1 AND 20
ORDER BY RowNumber ASC;

and this: http://msdn.microsoft.com/en-us/library/ms175972.aspx[^]

I think, depend on your conditions, you can use something like this to return praticular row:

SELECT *
FROM Yourtable
WHERE FieldID = @ID

More at: http://msdn.microsoft.com/en-us/library/ms188047.aspx[^]

You can use TOP clause to:

SELECT TOP(1) *
FROM (SELECT TOP(5) * FROM YourTable ORDER BY FieldID DESC) AS DT

More at: http://msdn.microsoft.com/en-us/library/ms189463.aspx[^]

select MAX(model) from Product where model in( select top 5 model from Product order by model );

这篇关于选择语句如何选择特定行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！