本文介绍了查询以查找列的nᵗʰ个最大值的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想找到一列的最大值2 nd ,3 rd ,... n th 。
I want to find 2nd, 3rd, ... nth maximum value of a column.
推荐答案您可以将列排序为降序格式,然后从第n行获取值。
You could sort the column into descending format and then just obtain the value from the nth row.
编辑::
根据评论请求进行了更新。 警告 完全未经测试!
Updated as per comment request. WARNING completely untested!
SELECT DOB FROM (SELECT DOB FROM USERS ORDER BY DOB DESC) WHERE ROWID = 6上述类似内容适用于Oracle ...您可能必须先正确使用语法!
Something like the above should work for Oracle ... you might have to get the syntax right first!
更多推荐
查询以查找列的nᵗʰ个最大值
发布评论