摘要: 1.部分SQL语句差异(1)SQL:select top 10 * from tableORA: select * from table where rownum11(2)SQL:Select * from t1 join t2 on t1.c1=t2.c1ORA: select * from t1,t2 where t1.c1=t2.c1(3)select * from t1 left join t2 on t1.c1=t2.c1ORA: select * from t1,t2 where t1.c1=t2.c1(+)(4)SQL:select * from t1 right join t 阅读全文
posted @ 2011-01-19 09:35 小さいです哥 阅读(452) 评论(0) 推荐(0)