如何获得第三高的价值? [英] How to get third heighest value ?

问题描述

请任何人让我知道如何从表中获得列的第三高值.

在此先谢谢您.

Hi,
Please anyone let me know how can I get 3rd highest value of a column from a table.

Thanks in advance.

推荐答案

您应该先在Google上查询，然后再问这里.

如果您拥有的话，您将获得超过1900万次的匹配，这应该会给您带来很多选择.

此 [

You should have googled before asking here.

If you had you would have got over 19,000,000 hits, which should have given you plenty of options.

this[^] is just one of them.

Found by using sql get nth highest value, in case you don''t like that one.

尝试:

SELECT 
  TOP 1 myColumnThatContainsNumbers
FROM
  (
    SELECT
       TOP 3 myColumnThatContainsNumbers
    FROM
       myTabele
    ORDER BY myColumnThatContainsNumbers DESC
  ) aliasTableName
ORDER BY myColumnThatContainsNumbers ASC

SELECT
    MAX(ID)
FROM
    MYTABLE A
WHERE
    (SELECT COUNT(ID) FROM MYTABLE B WHERE B.ID >= A.ID) = 3

这篇关于如何获得第三高的价值?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！