MySQL转换Oracle的需要注意的七个事项

复制代码 代码如下:

SELECT ID, [FIELD_NAME,...] FROM TABLE_NAME WHERE
ID IN ( SELECT ID FROM (SELECT ROWNUM AS NUMROW,
ID FROM TABLE_NAME WHERE 条件1 ORDER BY 条件2)
WHERE NUMROW > 80 AND NUMROW ＆lt; 100 ) ORDER BY 条件3;

复制代码 代码如下:

SELECT * FROM (( SELECT ROWNUM AS NUMROW,
c.* from (select [FIELD_NAME,...]
FROM TABLE_NAME WHERE 条件1 ORDER BY 条件2) c)
WHERE NUMROW > 80 AND NUMROW ＆lt; 100 ) ORDER BY 条件3;