两个选择上的UNION给出’SQL错误：ORA-00907：缺少右括号’

发布时间：2020-12-12 08:53:24 所属栏目：MsSql教程来源：网络整理

导读：我正在尝试UNION两个查询的结果.但是我收到以下错误： Error at Command Line:9 Column:81Error report:SQL Error: ORA-00907: missing right parenthesis00907. 00000 - "missing right parenthesis" 这是我的查询： SELECT application_id,clicks,datee,cli

我正在尝试UNION两个查询的结果.但是我收到以下错误：

Error at Command Line:9 Column:81
Error report:
SQL Error: ORA-00907: missing right parenthesis
00907. 00000 -  "missing right parenthesis"

这是我的查询：

SELECT application_id,clicks,datee,client_id FROM(
(select 
    APPL_CD AS application_id,count(*) as clicks,to_date((to_char(ACTN_TAKE_DATA_TM,'dd-mm-yyyy')),'dd-mm-yyyy') as datee,ALRT_RSPNS_FROM_CLIENT_ID AS client_id 
from  ALRT_PLATFORM_ALRT_HSTRY
    where  ACTN_TAKE_CD is not null 
    group by to_char(ACTN_TAKE_DATA_TM,'dd-mm-yyyy'),APPL_CD,ALRT_RSPNS_FROM_CLIENT_ID order by datee) 
UNION ALL
(select 
    APPL_CD AS application_id,ALRT_RSPNS_FROM_CLIENT_ID AS client_id 
from  ALRT_PLATFORM_ALRT
    where  ACTN_TAKE_CD is not null 
    group by to_char(ACTN_TAKE_DATA_TM,ALRT_RSPNS_FROM_CLIENT_ID order by datee )
)

解决方法

从嵌套查询中删除ORDER BY：

SELECT application_id,ALRT_RSPNS_FROM_CLIENT_ID) 
UNION ALL
(select 
    APPL_CD AS application_id,ALRT_RSPNS_FROM_CLIENT_ID )
)

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!