select ygbm,ygxm,(select case when ygxb = '1' then '男' else '女' end) as ygxb,ygmz,sfid,zzmm,ygsr,gzsj,byxx,xlmc,zcmc,jnmc,zwmc,lxdh,gzgw,memo from vw_ygb;
本文共 202 字，大约阅读时间需要 1 分钟。
select ygbm,ygxm,(select case when ygxb = '1' then '男' else '女' end) as ygxb,ygmz,sfid,zzmm,ygsr,gzsj,byxx,xlmc,zcmc,jnmc,zwmc,lxdh,gzgw,memo from vw_ygb;
转载于:https://www.cnblogs.com/xusy/p/4832384.html