2012年5月24日
oracle小记3-left join
摘要： select * from (select row_.*, rownum rownum_ from (select rownum "index", b.* from (select rownum, mc.cust_no "cust_no", c.cust_name "cust_name", c.cert_type "cert_type", c.cert_no "cert_no", c.open_way "open_way", ... 阅读全文
posted @ 2012-05-24 15:17 狂奔的蜗牛cn 阅读(261) 评论(0) 推荐(0)
oracle小记2-case使用
摘要： select * from (select row_.* from (select rownum rownum_, aa.name as approvalName, pd.MOBILEPHONE as MOBILEPHONE, abc.NAME, ga.APPLY_ID, ga.GROUP_NO, ga.APPLY_CLASS, ga.APPLY_STATUS, gr.GROUP_NAME, ... 阅读全文
posted @ 2012-05-24 14:27 狂奔的蜗牛cn 阅读(133) 评论(0) 推荐(0)