oracle数据库postgres数据库分页查询

夏之小星星

已于 2024-03-15 09:44:04 修改

阅读量255

点赞数 3

于 2024-03-15 09:43:25 首次发布

本文链接：https://blog.csdn.net/Cabriella_/article/details/136729171

版权

oracle数据库

<select id="GetDataByPage" resultType="java.lang.String">
	SELECT * FROM
	(
  		SELECT T.*, ROWNUM RN FROM 
  		(        
  			SELECT column1, column2, column3, column4, column5, column6 FROM tableName
        	WHERE column1='XXX' AND LENGTH(column2)=6                         
        	order by column6 ASC
   		) T
   		WHERE ROWNUM <![CDATA[<=]]> #{pageSize}*#{pageNumber}
	)
	WHERE RN >(#{pageSize}*#{pageNumber}-#{pageSize})                       
</select>

postgres数据库

<select id="GetDataByPage" resultType="java.lang.String">
      SELECT column1, column2, column3, column4, column5, column6 FROM tableName
      WHERE column1='XXX' AND LENGTH(column2)=6                         
      order by column6 ASC
      limit #{pageSize} offset #{pageSize}*(#{pageNumber}-1)
</select>