Offset (SQLBuilder 1.2 API)

java.lang.Object
- com.github.eikecochu.sqlbuilder.QueryPartImpl<Offset>
- - com.github.eikecochu.sqlbuilder.mssql.Offset

All Implemented Interfaces:

QueryBuilder<Offset>, QueryPart, QueryPartLinked<Offset>, QueryPartSQL<Offset>
```
public class Offset
extends QueryPartImpl<Offset>
implements QueryBuilder<Offset>
```
Offset statement Supported by MS SQL Server, Oracle 12c, PostgreSQL

Constructor Summary

Constructors
Modifier	Constructor	Description
	`Offset(int offset)`	Creates a new Offset instance with the offset to skip when selecting data
`protected`	`Offset(QueryPartLinked<?> parent, int offset)`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`Fetch`	`fetch(int fetch)`	Create a new Fetch statement with the amount of rows to be fetched
`java.lang.String`	`string(QueryOptions options)`	Transforms this statement into an SQL string

Methods inherited from class com.github.eikecochu.sqlbuilder.QueryPartImpl
parent, sql

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

Methods inherited from interface com.github.eikecochu.sqlbuilder.QueryBuilder
query, query

Methods inherited from interface com.github.eikecochu.sqlbuilder.QueryPart
string

Methods inherited from interface com.github.eikecochu.sqlbuilder.QueryPartLinked
ext, parent, parent

- Constructor Detail
  - Offset
```
public Offset(int offset)
```
    Creates a new Offset instance with the offset to skip when selecting data
    
    Parameters:
    
    offset - The offset to skip from the start
  - Offset
```
protected Offset(QueryPartLinked<?> parent,
                 int offset)
```
- Method Detail
  - fetch
```
public Fetch fetch(int fetch)
```
    Create a new Fetch statement with the amount of rows to be fetched
    
    Parameters:
    
    fetch - The amount of rows to be fetched
    
    Returns:
    
    the created Fetch instance
  - string
```
public java.lang.String string(QueryOptions options)
```
    Description copied from interface: QueryPart
    
    Transforms this statement into an SQL string
    
    Specified by:
    
    string in interface QueryPart
    
    Parameters:
    
    options - The QueryOptions to apply for transformation
    
    Returns:
    
    The created SQL string