摘要:
select res.id, res.title,res.stype,res.urls,decode(res.stype,1,'新闻',decode(res.stype,2,'帮助',decode(res.stype,3,'解决方案',decode(res.stype,4,'产品',decode(res.stype,5,'咨询'))))) as sstype from ( select id,1 as stype, SUBSTR(NEWSTITLE,0,25) as title ,'n_view.aspx? 阅读全文