public interface SqlLimitRequest
The request object for the query that can have sql limiting applied to it
(such as a LIMIT OFFSET clause).
-
Method Summary
Modifier and TypeMethodDescriptionReturn ANSI SQL Offset and next rows.Return the orderBy clause of the sql query.return the database platformgetDbSql()
Return the sql query.int
Return the first row value.int
Return the max rows for this query.Query
<?> return the queryboolean
Return true if the query uses distinct.Create and return buffer including the select distinct clause.Create and return buffer including the select distinct on clause.
-
Method Details
-
ansiOffsetRows
String ansiOffsetRows()Return ANSI SQL Offset and next rows. -
selectDistinct
StringBuilder selectDistinct()Create and return buffer including the select distinct clause. -
selectDistinctOnSql
StringBuilder selectDistinctOnSql()Create and return buffer including the select distinct on clause. -
isDistinct
boolean isDistinct()Return true if the query uses distinct. -
getFirstRow
int getFirstRow()Return the first row value. -
getMaxRows
int getMaxRows()Return the max rows for this query. -
getDbSql
String getDbSql()Return the sql query. -
getDbOrderBy
String getDbOrderBy()Return the orderBy clause of the sql query. -
getOrmQuery
Query<?> getOrmQuery()return the query -
getDbPlatform
DatabasePlatform getDbPlatform()return the database platform
-