当前位置：
首页 >
sql查询结果字段名与字段值倒过来了
发布时间：2023/12/2
62
豆豆
生活随笔
收集整理的这篇文章主要介绍了
sql查询结果字段名与字段值倒过来了
小编觉得挺不错的,现在分享给大家,帮大家做个参考.
数据库为sybase,
sql如下：
1 select substring(LRRJG,1,7) as SSQJ, 2 sum(case when RWDL_BH = '01' then 1 else 0 end) AS A, 3 sum(case when RWDL_BH = '01' and XBHSJG != null then 1 else 0 end) AS B 4 from ZYH_DBRW_LRNSRRW 5 where LR_DBRW_ID != null and DR = 0 and LRSJ >= '2012-10-01' and LRSJ <= '2012-11-01' 6 group by substring(LRRJG,1,7)这样查询结果为：
| SSQJ | A | B |
| 2420102 | 0 | 0 |
| 2420106 | 8 | 6 |
sql更改为如下：
1 select b.ORGAN_CODE,RES.* 2 from SM_ORGANISE b left join ( 3 select substring(LRRJG,1,7) as SSQJ, 4 sum(case when RWDL_BH = '01' then 1 else 0 end) AS A, 5 sum(case when RWDL_BH = '01' and XBHSJG != null then 1 else 0 end) AS B 6 from ZYH_DBRW_LRNSRRW 7 where LR_DBRW_ID != null and DR = 0 and LRSJ >= '2012-10-01' and LRSJ <= '2012-11-01' 8 group by substring(LRRJG,1,7) 9 ) as RES on RES.SSQJ + '0000'=b.ORGAN_CODE查询结果如下：(正常)
| ORGAN_CODE | SSQJ | A | B |
| 24201060000 | 2420106 | 8 | 6 |
| 24201020000 | 2420102 | 0 | 0 |
| 24201000000 | (null) | (null) | (null) |
sql更改为如下：
1 select b.ORGAN_CODE,RES.* 2 from SM_ORGANISE b left join ( 3 select substring(LRRJG,1,7) + '0000' as SSQJ, 4 sum(case when RWDL_BH = '01' then 1 else 0 end) AS A, 5 sum(case when RWDL_BH = '01' and XBHSJG != null then 1 else 0 end) AS B 6 from ZYH_DBRW_LRNSRRW 7 where LR_DBRW_ID != null and DR = 0 and LRSJ >= '2012-10-01' and LRSJ <= '2012-11-01' 8 group by substring(LRRJG,1,7)+'0000' 9 ) as RES on RES.SSQJ=b.ORGAN_CODE 10 where ORGAN_CODE like '%0000'查询结果如下：（字段名和字段值倒过来了）
| ORGAN_CODE | SSQJ | A | B |
| 24201060000 | 24201060000 | 6 | 8 |
| 24201020000 | 24201020000 | 0 | 0 |
| 24201000000 | (null) | (null) | (null) |
不知道问什么会这样，是否跟数据库底层的运算机制有关？
转载于:https://www.cnblogs.com/dingshuai/archive/2012/11/01/2749780.html
总结
以上是生活随笔为你收集整理的sql查询结果字段名与字段值倒过来了的全部内容，希望文章能够帮你解决所遇到的问题。
