Sql Query Question 2.最高值 [英] Sql Query Question 2. highest value

问题描述

此查询从表中查找第二个最高ID



但是我的问题如何（Where子句执行）？

LIke WHERE（2）

  SELECT  Id 
  FROM  testTabel2 test1 
  WHERE （ 2 ）= 
 
（
  SELECT  COUNT（ DISTINCT （test2.Id））
  FROM  testTabel2 test2 
  WHERE  test2.Id> test1.Id）

解决方案

试试这个：

  SELECT  * 
  FROM （
  SELECT  ID，ROW_NUMBER（） OVER （ ORDER   BY  ID  Desc ） AS  RowNo 
  FROM 表1） AS  T 
  WHERE  RowNo =  2  

更多关于： ROW_NUMBER（）T-SQL [ ^ ]



或

  SELECT   TOP （ 1 ）ID 
  FROM （
  SELECT   TOP （ 2 ）ID 
  FROM  Table1 
  ORDER  < span class =code-keyword> BY  ID  DESC ） AS  T 
  ORDER   BY  ID  ASC  

This Query Find Second Highest Id From table

But My question There How (Where Clause Execute)?
LIke WHERE (2)

SELECT Id
FROM testTabel2 test1
WHERE (2) =
 
(
SELECT COUNT(DISTINCT(test2.Id ))
FROM testTabel2 test2
WHERE test2.Id >test1.Id )

解决方案

Try this:

SELECT *
FROM (
    SELECT ID, ROW_NUMBER() OVER(ORDER BY ID Desc) AS RowNo
    FROM Table1) AS T
WHERE RowNo = 2

More about: ROW_NUMBER() T-SQL[^]

or

SELECT TOP(1) ID
FROM (
    SELECT TOP(2) ID
    FROM Table1
    ORDER BY ID DESC) AS T
ORDER BY ID ASC 

这篇关于Sql Query Question 2.最高值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！