- All Superinterfaces:
- Fields,- GroupField,- Named,- Qualified,- QueryPart,- RecordQualifier<R>,- SelectField<R>,- SelectFieldOrAsterisk,- Serializable,- Table<R>,- TableLike<R>,- TableSampleRepeatableStep<R>,- Typed<R>
A step in the construction of the Referencing 
 
TABLESAMPLE function.
 
Referencing XYZ*Step types directly from client code
 
 It is usually not recommended to reference any XYZ*Step types
 directly from client code, or assign them to local variables. When writing
 dynamic SQL, creating a statement's components dynamically, and passing them
 to the DSL API statically is usually a better choice. See the manual's
 section about dynamic SQL for details: https://www.jooq.org/doc/latest/manual/sql-building/dynamic-sql.
 
 Drawbacks of referencing the XYZ*Step types directly:
 
- They're operating on mutable implementations (as of jOOQ 3.x)
- They're less composable and not easy to get right when dynamic SQL gets complex
- They're less readable
- They might have binary incompatible changes between minor releases
- 
Method SummaryModifier and TypeMethodDescription@NotNull TableSampleRepeatableStep<R> percent()Add thePERCENTclause to theTABLESAMPLEfunction.@NotNull TableSampleRepeatableStep<R> rows()Add theROWSclause to theTABLESAMPLEfunction.Methods inherited from interface org.jooq.FieldsdataType, dataType, dataType, dataTypes, field, field, field, field, field, field, field, field, field, field, fields, fields, fields, fields, fields, fieldsIncludingHidden, fieldsRow, fieldStream, indexOf, indexOf, indexOf, type, type, type, typesMethods inherited from interface org.jooq.Named$name, getComment, getCommentPart, getName, getQualifiedName, getUnqualifiedNameMethods inherited from interface org.jooq.Qualified$schema, getCatalog, getSchemaMethods inherited from interface org.jooq.QueryPart$replace, $replace, $traverse, $traverse, hashCode, toStringMethods inherited from interface org.jooq.RecordQualifiergetDataType, getPackage, getRecordType, newRecordMethods inherited from interface org.jooq.SelectFieldas, convert, convert, convert, convertFrom, convertFrom, convertTo, convertToMethods inherited from interface org.jooq.Tableas, as, as, as, as, as, as, as, as, as, as, as, as, as, as, asOfScn, asOfScn, asOfTimestamp, asOfTimestamp, asterisk, at, at, at, crossApply, crossApply, crossApply, crossApply, crossApply, crossApply, crossJoin, crossJoin, crossJoin, crossJoin, crossJoin, crossJoin, divideBy, eq, equal, equals, for_, forceIndex, forceIndexForGroupBy, forceIndexForJoin, forceIndexForOrderBy, forPortionOf, from, fullHashJoin, fullHashJoin, fullJoin, fullJoin, fullJoin, fullJoin, fullJoin, fullJoin, fullJoin, fullLoopJoin, fullLoopJoin, fullMergeJoin, fullMergeJoin, fullOuterHashJoin, fullOuterHashJoin, fullOuterJoin, fullOuterJoin, fullOuterJoin, fullOuterJoin, fullOuterJoin, fullOuterJoin, fullOuterJoin, fullOuterLoopJoin, fullOuterLoopJoin, fullOuterMergeJoin, fullOuterMergeJoin, getChecks, getIdentity, getIndexes, getKeys, getOptions, getPrimaryKey, getRecordTimestamp, getRecordVersion, getReferences, getReferencesFrom, getReferencesTo, getTableType, getTriggers, getUniqueKeys, hashJoin, hashJoin, ignoreIndex, ignoreIndexForGroupBy, ignoreIndexForJoin, ignoreIndexForOrderBy, innerHashJoin, innerHashJoin, innerJoin, innerJoin, innerJoin, innerJoin, innerJoin, innerJoin, innerJoin, innerLoopJoin, innerLoopJoin, innerMergeJoin, innerMergeJoin, join, join, join, join, join, join, join, join, join, leftAntiJoin, leftAntiJoin, leftHashJoin, leftHashJoin, leftJoin, leftJoin, leftJoin, leftJoin, leftJoin, leftJoin, leftJoin, leftLoopJoin, leftLoopJoin, leftMergeJoin, leftMergeJoin, leftOuterHashJoin, leftOuterHashJoin, leftOuterJoin, leftOuterJoin, leftOuterJoin, leftOuterJoin, leftOuterJoin, leftOuterJoin, leftOuterJoin, leftOuterLoopJoin, leftOuterLoopJoin, leftOuterMergeJoin, leftOuterMergeJoin, leftSemiJoin, leftSemiJoin, loopJoin, loopJoin, mergeJoin, mergeJoin, naturalFullOuterJoin, naturalFullOuterJoin, naturalFullOuterJoin, naturalFullOuterJoin, naturalFullOuterJoin, naturalFullOuterJoin, naturalJoin, naturalJoin, naturalJoin, naturalJoin, naturalJoin, naturalJoin, naturalLeftOuterJoin, naturalLeftOuterJoin, naturalLeftOuterJoin, naturalLeftOuterJoin, naturalLeftOuterJoin, naturalLeftOuterJoin, naturalRightOuterJoin, naturalRightOuterJoin, naturalRightOuterJoin, naturalRightOuterJoin, naturalRightOuterJoin, naturalRightOuterJoin, ne, notEqual, outerApply, outerApply, outerApply, outerApply, outerApply, outerApply, partitionBy, partitionBy, pivot, pivot, pivot, recordType, rightHashJoin, rightHashJoin, rightJoin, rightJoin, rightJoin, rightJoin, rightJoin, rightJoin, rightJoin, rightLoopJoin, rightLoopJoin, rightMergeJoin, rightMergeJoin, rightOuterHashJoin, rightOuterHashJoin, rightOuterJoin, rightOuterJoin, rightOuterJoin, rightOuterJoin, rightOuterJoin, rightOuterJoin, rightOuterJoin, rightOuterLoopJoin, rightOuterLoopJoin, rightOuterMergeJoin, rightOuterMergeJoin, rowid, straightJoin, straightJoin, straightJoin, straightJoin, straightJoin, straightJoin, straightJoin, tablesample, tablesample, tablesampleBernoulli, tablesampleBernoulli, tablesampleSystem, tablesampleSystem, useIndex, useIndexForGroupBy, useIndexForJoin, useIndexForOrderBy, versionsBetweenScn, versionsBetweenScn, versionsBetweenScnMinvalue, versionsBetweenTimestamp, versionsBetweenTimestamp, versionsBetweenTimestampMinvalue, where, where, where, where, where, where, where, where, whereExists, whereNotExists, with, with, with, with, withOrdinalityMethods inherited from interface org.jooq.TableLikeasMultiset, asMultiset, asMultiset, asMultiset, asTable, asTable, asTable, asTable, asTable, asTable, asTable, asTable, asTable, asTable, asTable, asTableMethods inherited from interface org.jooq.TableSampleRepeatableSteprepeatable, repeatableMethods inherited from interface org.jooq.Typed$dataType, getBinding, getConverter, getDataType, getDataType, getType
- 
Method Details- 
rows@Support({AURORA_POSTGRES,CLICKHOUSE,DATABRICKS,DUCKDB,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,VERTICA}) @NotNull @CheckReturnValue @NotNull TableSampleRepeatableStep<R> rows()Add theROWSclause to theTABLESAMPLEfunction.The sampling size is a specific number of rows. 
- 
percent@Support({AURORA_POSTGRES,BIGQUERY,CLICKHOUSE,DATABRICKS,DB2,DUCKDB,HANA,ORACLE,POSTGRES,SNOWFLAKE,SPANNER,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,TRINO,VERTICA}) @NotNull @CheckReturnValue @NotNull TableSampleRepeatableStep<R> percent()Add thePERCENTclause to theTABLESAMPLEfunction.The sampling size is a specific percentage of rows. This is the default. 
 
-