帮我看看这个查询，总报错！！！

[zhaoyongzhu]

SQL> (select pp from (select id as pp from test1 union all select p1 as pp from test1) order by pp d
esc)
2 minus
3 (select max(pp) as pp from (select id as pp from test1 union all select p1 as pp from test1));

(select pp from (select id as pp from test1 union all select p1 as pp from test1) order by pp desc)
*
ERROR at line 1:
ORA-00907: missing right parenthesis

我的本意是求id和p1的第二大值。

[zhaoyongzhu]

表结构为：
SQL> select * from test1;

ID ZYZ1 P1 DOCTIME
---------- ---------- ---------- ----------
1 dfdf 2
1 2 01-5ÔÂ -02
1 2 20-8ÔÂ -02
1 df0 2

求出的第二大值应该为2

[hdkkk]

minus完了再order by

[zhaoyongzhu]

我不进行order by 怎么minus呀。

[jlandzpa]

你的语句等价于：
(select id as pp from test1
union all
select p1 as pp from test1)
minus
(select max(id) as pp from test1
union
select max(p1) as pp from test1);

但却不是求id和p1的第二大值。

[zhaoyongzhu]

看来是分给的少了。那就在开一贴吧。