# Uses of Class
org.springframework.batch.item.database.support.AbstractSqlPagingQueryProvider

Packages that use AbstractSqlPagingQueryProvider
Package
Description
org.springframework.batch.item.database.support
Support classes for database specific semantics.

- ## Uses of AbstractSqlPagingQueryProvider in org.springframework.batch.item.database.support

  Subclasses of AbstractSqlPagingQueryProvider in org.springframework.batch.item.database.support
  Modifier and Type
  Class
  Description
  `class`
  `Db2PagingQueryProvider`
  DB2 implementation of a `PagingQueryProvider` using database specific features.
  `class`
  `DerbyPagingQueryProvider`
  Derby implementation of a `PagingQueryProvider` using standard SQL:2003 windowing functions.
  `class`
  `H2PagingQueryProvider`
  H2 implementation of a `PagingQueryProvider` using database specific features.
  `class`
  `HsqlPagingQueryProvider`
  HSQLDB implementation of a `PagingQueryProvider` using database specific features.
  `class`
  `MySqlPagingQueryProvider`
  MySQL implementation of a `PagingQueryProvider` using database specific features.
  `class`
  `OraclePagingQueryProvider`
  Oracle implementation of a `PagingQueryProvider` using database specific features.
  `class`
  `PostgresPagingQueryProvider`
  Postgres implementation of a `PagingQueryProvider` using database specific features.
  `class`
  `SqlitePagingQueryProvider`
  SQLite implementation of a `PagingQueryProvider` using database specific features.
  `class`
  `SqlServerPagingQueryProvider`
  SQL Server implementation of a `PagingQueryProvider` using database specific features.
  `class`
  `SqlWindowingPagingQueryProvider`
  Generic Paging Query Provider using standard SQL:2003 windowing functions.
  `class`
  `SybasePagingQueryProvider`
  Sybase implementation of a `PagingQueryProvider` using database specific features.
  Methods in org.springframework.batch.item.database.support with parameters of type AbstractSqlPagingQueryProvider
  Modifier and Type
  Method
  Description
  `static String`
  SqlPagingQueryUtils.`buildSortClause(AbstractSqlPagingQueryProvider provider)`
  Generates ORDER BY attributes based on the sort keys.
  `static void`
  SqlPagingQueryUtils.`buildSortConditions(AbstractSqlPagingQueryProvider provider, StringBuilder sql)`
  Appends the where conditions required to query for the subsequent pages.
  `static String`
  SqlPagingQueryUtils.`generateGroupedTopSqlQuery(AbstractSqlPagingQueryProvider provider, boolean remainingPageQuery, String topClause)`
  Generate SQL query string using a TOP clause
  `static String`
  SqlPagingQueryUtils.`generateLimitGroupedSqlQuery(AbstractSqlPagingQueryProvider provider, boolean remainingPageQuery, String limitClause)`
  Deprecated.
  as of v5.0 in favor of `SqlPagingQueryUtils.generateLimitGroupedSqlQuery(AbstractSqlPagingQueryProvider, java.lang.String)`
  `static String`
  SqlPagingQueryUtils.`generateLimitGroupedSqlQuery(AbstractSqlPagingQueryProvider provider, String limitClause)`
  Generate SQL query string using a LIMIT clause
  `static String`
  SqlPagingQueryUtils.`generateLimitJumpToQuery(AbstractSqlPagingQueryProvider provider, String limitClause)`
  Generate SQL query string using a LIMIT clause
  `static String`
  SqlPagingQueryUtils.`generateLimitSqlQuery(AbstractSqlPagingQueryProvider provider, boolean remainingPageQuery, String limitClause)`
  Generate SQL query string using a LIMIT clause
  `static String`
  SqlPagingQueryUtils.`generateRowNumSqlQuery(AbstractSqlPagingQueryProvider provider, boolean remainingPageQuery, String rowNumClause)`
  Generate SQL query string using a ROW_NUM condition
  `static String`
  SqlPagingQueryUtils.`generateRowNumSqlQuery(AbstractSqlPagingQueryProvider provider, String selectClause, boolean remainingPageQuery, String rowNumClause)`
  Generate SQL query string using a ROW_NUM condition
  `static String`
  SqlPagingQueryUtils.`generateRowNumSqlQueryWithNesting(AbstractSqlPagingQueryProvider provider, String selectClause, boolean remainingPageQuery, String rowNumClause)`
  `static String`
  SqlPagingQueryUtils.`generateRowNumSqlQueryWithNesting(AbstractSqlPagingQueryProvider provider, String innerSelectClause, String outerSelectClause, boolean remainingPageQuery, String rowNumClause)`
  `static String`
  SqlPagingQueryUtils.`generateTopJumpToQuery(AbstractSqlPagingQueryProvider provider, String topClause)`
  Generate SQL query string using a TOP clause
  `static String`
  SqlPagingQueryUtils.`generateTopSqlQuery(AbstractSqlPagingQueryProvider provider, boolean remainingPageQuery, String topClause)`
  Generate SQL query string using a TOP clause