+ -
当前位置:首页 → 问答吧 → IQ count(distinct)出错,怎么解决

IQ count(distinct)出错,怎么解决

时间:2010-09-08

来源:互联网

读取 SQL 语句的结果时出错。
所显示的结果可能不正确或不完整。
'Sort'
-- (s_csort.cxx 808)
SQLCODE=-1009134,ODBC 3 状态="HY000"

select
count(distinct H0  )c01,
count(distinct ID  )c02,
count(distinct H02 )c03,
count(distinct H031)c04,
count(distinct H032)c05,
count(distinct H041)c06,
count(distinct H042)c07,
count(distinct H051)c08,
count(distinct H052)c09,
count(distinct H061)c10,
count(distinct H062)c11,
count(distinct H071)c12,
count(distinct H072)c13,
count(distinct H081)c14,
count(distinct H082)c15,
count(distinct H09 )c16,
count(distinct H10 )c17,
count(distinct H11 )c18,
count(distinct H12 )c19,
count(distinct H13 )c20,
count(distinct H14 )c21,
count(distinct H15 )c22,
count(distinct H16 )c23,
count(distinct H17 )c24,
count(distinct H18 )c25,
count(distinct H19 )c26,
count(distinct H20 )c27,
count(distinct H21 )c28,
count(distinct H22 )c29,
count(distinct H23 )c30,
count(distinct HA0 )c31,
count(distinct HA1 )c32,
count(distinct HA2 )c33,
count(distinct HA3 )c34,
count(distinct HA4 )c35,
count(distinct HA5 )c36,
count(distinct HA6 )c37,
count(distinct HA7 )c38,
count(distinct HA8 )c39,
count(distinct HA9 )c40,
count(distinct HA10)c41,
count(distinct HA11)c42,
count(distinct HA20)c43
from hu;

作者: 〇〇   发布时间: 2010-09-08

偶从来没有见这个么多的count + distinct 字段的
今天 长见识了 :)

作者: cityvigil   发布时间: 2010-09-08

相关阅读 更多

热门下载

更多