在oracle数据库中,怎么查询年龄岁数第三大的人。查询语句怎么写。年龄的...答:SELECT STU_NAME , 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...
对Oracle数据库中查询出表的结果,实现如下效果答:WITH TAB AS(SELECT 'a1' AS A,'b1' AS B FROM DUAL UNION SELECT 'a2' AS A,'b2' AS B FROM DUAL )SELECT A,NULL AS B,DECODE(A,'a1',B,'') AS C,DECODE(A,'a2',B,'') D from tab;这是测试语句,真正的语句是去掉上面的WITH语句,如下:SELECT A,NULL AS B,DECODE(A,...