TopLimitHandler (Hibernate Javadocs)

java.lang.Object
- org.hibernate.dialect.pagination.AbstractLimitHandler
- - org.hibernate.dialect.pagination.AbstractNoOffsetLimitHandler
  - - org.hibernate.dialect.pagination.TopLimitHandler

All Implemented Interfaces:

LimitHandler
```
public class TopLimitHandler
extends AbstractNoOffsetLimitHandler
```
A LimitHandler for Transact SQL and similar databases which support the syntax SELECT TOP n. Note that this syntax does not allow specification of an offset.

Field Summary

Fields
Modifier and Type Field Description

static TopLimitHandler INSTANCE
- Fields inherited from class org.hibernate.dialect.pagination.AbstractLimitHandler
  NO_LIMIT

Constructor Summary

Constructors
Constructor Description

TopLimitHandler(boolean variableLimit)

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`boolean`	`bindLimitParametersFirst()`	Does the offset/limit clause come at the start of the `SELECT` statement, or at the end of the query?
`protected String`	`insert(String limitClause, String sql)`
`protected String`	`limitClause()`	The SQL fragment to insert, with a ? placeholder for the actual numerical limit.

Methods inherited from class org.hibernate.dialect.pagination.AbstractNoOffsetLimitHandler
processSql, supportsLimit, supportsLimitOffset, supportsVariableLimit

Methods inherited from class org.hibernate.dialect.pagination.AbstractLimitHandler
bindLimitParameters, bindLimitParametersAtEndOfQuery, bindLimitParametersAtStartOfQuery, bindLimitParametersInReverseOrder, convertToFirstRowValue, forceLimitUsage, getFirstRow, getForUpdatePattern, getMaxOrLimit, hasFirstRow, hasMaxRows, insertAfterDistinct, insertAfterSelect, insertAtEnd, insertBeforeForUpdate, setMaxRows, supportsOffset, useMaxForLimit

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface org.hibernate.dialect.pagination.LimitHandler
processSql

- Field Detail
  - INSTANCE
```
public static TopLimitHandler INSTANCE
```
- Constructor Detail
  - TopLimitHandler
```
public TopLimitHandler(boolean variableLimit)
```
- Method Detail
  - limitClause
```
protected String limitClause()
```
    Description copied from class: AbstractNoOffsetLimitHandler
    
    The SQL fragment to insert, with a ? placeholder for the actual numerical limit.
    
    Specified by:
    
    limitClause in class AbstractNoOffsetLimitHandler
  - insert
```
protected String insert(String limitClause,
                        String sql)
```
    Specified by:
    
    insert in class AbstractNoOffsetLimitHandler
  - bindLimitParametersFirst
```
public boolean bindLimitParametersFirst()
```
    Description copied from class: AbstractLimitHandler
    
    Does the offset/limit clause come at the start of the SELECT statement, or at the end of the query?
    
    Specified by:
    
    bindLimitParametersFirst in class AbstractNoOffsetLimitHandler
    
    Returns:
    
    true if limit parameters come before other parameters