ORACLE和SQLServer SQL语句的区别.docVIP

ORACLE和SQLServer SQL语句的区别 S: SQL?? Server: ?O: Oracle: ?? ??S: Select?? top?? 1?? *?? from?? tablename?? ??O: Select?? *?? from?? tablename?? where?? rownum?? ?? 2 ?? ?? ??S: Select?? A.*,?? B.*?? from?? A?? left?? Join?? B?? on?? A.bh=B.bh ??O: Select?? A.*,?? B.*?? from?? A,?? B?? where?? A.bh=B.bh(+) ?? ??S: Select?? A.*,?? B.*?? from?? A?? right?? join?? B?? where?? A.bh=B.bh ??O: Select?? A.*,?? B.*?? from?? A,?? B?? where?? A.bh(+)=B.bh ?? ?注：oracle9开始支持join写法 ?S: Select?? *?? from?? tablename?? where?? lrsj?? =?? ‘2002-11-11’ ??O: Select?? *?? from?? tablename?? where??