RDBMS

★SQL ServerとOracleの比較

S：SELECT TOP 10 * FROM table

O：SELECT * FROM table WHERE ROWNUM < 11

S：SELECT * FROM table1 INNER JOIN table2 ON table1.col1 = table2.col1

O：SELECT * FROM table1, table2 WHERE table1.col1 = table2.col1

S：SELECT * FROM table1 LEFT JOIN table2 ON table1.col1 = table2.col1

O：SELECT * FROM table1, table2 WHERE table1.col1 = table2.col1(+)

S：SELECT * FROM table1 RIGHT JOIN table2 on table1.col1 = table2.col1

O：SELECT * FROM table1, table2 WHERE table1.col1(+) = table2.col1