语句如下:
select distinct case when fwlb='20' and nvl(trim(wlcs),'0')='0' then '-100' when fwlb='20' then trim(wlcs) else nvl(trim(wlcs),'0') end as LC,fwlb from HouseEntity T where ID_LID = ? and SFYX = '1' order by fwlb,case when fwlb='20' and nvl(trim(wlcs),'0')='0' then '-100' when fwlb='20' then trim(wlcs) else nvl(trim(wlcs),'0') end desc
希望在红字部分LC,fwlb后加一个对这两个字段的连接,像sql中写法LC||'_'||fwlb as fwlb1Hibernatehqlconcatsql
select distinct case when fwlb='20' and nvl(trim(wlcs),'0')='0' then '-100' when fwlb='20' then trim(wlcs) else nvl(trim(wlcs),'0') end as LC,fwlb from HouseEntity T where ID_LID = ? and SFYX = '1' order by fwlb,case when fwlb='20' and nvl(trim(wlcs),'0')='0' then '-100' when fwlb='20' then trim(wlcs) else nvl(trim(wlcs),'0') end desc
希望在红字部分LC,fwlb后加一个对这两个字段的连接,像sql中写法LC||'_'||fwlb as fwlb1Hibernatehqlconcatsql
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货