sql
文章平均质量分 76
beMyselfeveryday
这个作者很懒,什么都没留下…
展开
-
LEFT JOIN RIGHT JOIN INNER JOIN的区别
--参考:http://www.cnblogs.com/pcjim/articles/799302.html SELECT * FROM (SELECT ROWNUM AS RN,C.* FROM ( SELECT A.BBID,ML.MLBHMC,MB.MBBH||' '||MB.MBMC AS MBBHMC,A.DJBH,A.DQZT,FJCO原创 2015-03-19 14:29:00 · 813 阅读 · 0 评论 -
sql语句 unit all和unit
例子: select * from (Select WDID, GLWDZD, WDBH, WDMC, CJRQ From STA_WD A LEFT JOIN SYS_WD_ZD B ON A.GLWDZD = B.BH where b.bh in ('ZZ','QJ','ZLX') ORDER BY B.XSSX) uni原创 2015-03-03 14:57:28 · 7156 阅读 · 0 评论