select rowname, wm_concat(CASE colname WHEN '0' THEN cnt ELSE null END) AS "0" FROM(
select rowname,1 roworder,colname,cnt from tmp_whq_guizhou_t where rowname='北京市' ) GROUP BY ROWNAME
查询出现:1 北京市 <CLOB>
我没有定义CLOB类型啊
...全文
1485打赏收藏
select 问题求教
select rowname, wm_concat(CASE colname WHEN '0' THEN cnt ELSE null END) AS "0" FROM( select rowname,1 roworder,colname,cnt from tmp_whq_guizhou_t where rowname='北京市' ) GROUP BY ROWNAME 查询出现:1北京市 我没有定义CLOB类型啊