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;
所显示的结果可能不正确或不完整。
'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
相关阅读 更多
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28