没明白楼主啥意思 select col from( (select num from t1 where...) - (select num from t2 where...)col )
就是一个(select num from t1 where...)结果是5 另一个select count出来是3 我想直接获取两个相减的结果2怎么直接用一个语句写select col from( (select num from t1 where...) - (select num from t2 where...) )col[Err] ORA-00907: missing right parenthesis
select (select num from t1 where...) - (select num from t2 where...) afrom dual
select col from(
(select num from t1 where...) - (select num from t2 where...)col
)
我想直接获取两个相减的结果2怎么直接用一个语句写select col from(
(select num from t1 where...) - (select num from t2 where...)
)col[Err] ORA-00907: missing right parenthesis