Oracle转PostgreSQL
最近在做一些Oracle SQL转PostgreSQL的工作,顺便记录这些改变,以便以后再转换有个参考。描述OraclePostgreSQL分页select * from ( select z.*,rownum as num from( " + sql + " ) z ) where num>=" + startRow + " and num<=" + endRowselect z.* from ( " + sql + " ) z LIMIT " + pageS