从选择row_number()over()中选择的JPQL [英] JPQL for select from select row_number() over()

问题描述

我在AS/400上使用Db2，并且试图执行JPQL查询，该查询将从x行返回到y行.

I'm using Db2 on AS/400, and I am trying to execute a JPQL query that will return results from row x to row y.

在SQL中有效:

select cur.* from (
  SELECT ROW_NUMBER() OVER() AS ROWNUM FROM tableName d) as cur
WHERE cur.ROWNUM > 0 AND cur.ROWNUM < 10

如何在JQPL中做到这一点?我尝试了很多方法，但是每次遇到异常时都可以.

How can I do this in JQPL? I tried it in many ways but every time I got an exception.

我想限制查询中的结果，而不是使用setMaxResult和setFirstResult方法.

I want to limit my result inside the query, and not by using the setMaxResult, setFirstResult methods.

推荐答案

无法完成. JPQL对实体进行操作，并将实体映射到数据库中的表. db2中的行号是结果集中的概念，而不是数据库表中的概念.

That cannot be done. JPQL operates to entities and entities are mapped to tables in database. Row number in db2 is concept in result set, not in database table.

这篇关于从选择row_number()over()中选择的JPQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！