IBM Informix-SQL语法错误，从Microsoft BIDS到Cisco UCCX数据库的基本查询 [英] IBM Informix-SQL syntax error, basic query from Microsoft BIDS to Cisco UCCX database

问题描述

我正在对IBM Informix数据库运行以下查询并获取ERROR 42000: A syntax error has occurred. FROM和WHERE子句在其他查询中运行良好，因此我正在研究SELECT和GROUP BY部分.任何想法语法有什么问题吗?

I'm running the below query against an IBM Informix database and getting an ERROR 42000: A syntax error has occurred. The FROM and WHERE clauses run fine in other queries, so I'm looking at the SELECT and GROUP BY portions. Any ideas what's wrong with the syntax?

SELECT COUNT(DISTINCT "informix".agentconnectiondetail.sessionid) AS calls_abandoned, 
DAY("informix".agentconnectiondetail.startdatetime) AS Expr2

FROM         "informix".agentconnectiondetail, "informix".contactqueuedetail, "informix".contactservicequeue

WHERE     "informix".agentconnectiondetail.sessionid = "informix".contactqueuedetail.sessionid AND 
                      "informix".contactqueuedetail.targetid = "informix".contactservicequeue.recordid AND "informix".contactqueuedetail.disposition = 1 AND 
                      "informix".agentconnectiondetail.startdatetime BETWEEN '2016-10-1 00:00:00' AND CURRENT

GROUP BY DAY("informix".agentconnectiondetail.startdatetime)

目标btw是查找每月的每一天(1-31)发生的唯一呼叫总数(calls_abandoned).

The goal btw is to find the total number of unique calls (calls_abandoned) that occur on each day of the month (1-31).

推荐答案

替换

GROUP BY DAY("informix" .agentconnectiondetail.startdatetime)

GROUP BY DAY("informix".agentconnectiondetail.startdatetime)

作者

2人组

这篇关于IBM Informix-SQL语法错误，从Microsoft BIDS到Cisco UCCX数据库的基本查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！