...怎么查询年龄岁数第三大的人。查询语句怎么写。年龄的字段是...答:, MAX( DECODE( RANK, 1, STU_AGE ) ) AS MAXVAL1 --年龄第一大 , MAX( DECODE( RANK, 2, STU_AGE ) ) AS MAXVAL2 --年龄第二大 , MAX( DECODE( RANK, 2, STU_AGE ) ) AS MAXVAL3 --年龄第三大 FROM (SELECT T.STU_NAME, T.STU_AGE, RANK() OVER ( PARTITION BY...