查询以查找列的第n个最大值 [英] Query to find nth max value of a column

问题描述

我想要查找列的第2，3rd..nth个最大值

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.

EDIT ::

根据注释请求更新。 警告

Updated as per comment request. WARNING completely untested!

SELECT DOB FROM (SELECT DOB FROM USERS ORDER BY DOB DESC) WHERE ROWID = 6

可能必须先获得语法！

这篇关于查询以查找列的第n个最大值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！