Available in versions: Dev (3.20) | Latest (3.19) | 3.18 | 3.17 | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11 | 3.10

This documentation is for the unreleased development version of jOOQ. Click on the above version links to get this documentation for a supported version of jOOQ.

SQL Statements (DML)

Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition

jOOQ currently supports 5 types of SQL statements. All of these statements are constructed from a DSLContext instance with an optional JDBC Connection or DataSource. If supplied with a Connection or DataSource, they can be executed. Depending on the query type, executed queries can return results.

3.5.1.: The WITH clause
3.5.2.: The WITH RECURSIVE clause
3.5.3.: The SELECT statement
3.5.3.1.: SELECT clause
3.5.3.1.1.: Projection type safety
3.5.3.1.2.: SelectField
3.5.3.1.3.: Tables as SelectField
3.5.3.1.4.: SELECT *
3.5.3.1.5.: SELECT * EXCEPT (...)
3.5.3.1.6.: SELECT DISTINCT
3.5.3.1.7.: SELECT DISTINCT ON
3.5.3.1.8.: Convenience methods
3.5.3.2.: FROM clause
3.5.3.3.: JOIN operator
3.5.3.4.: Implicit path JOIN
3.5.3.5.: Implicit to-many path JOIN
3.5.3.6.: Explicit path JOIN
3.5.3.7.: Implicit path correlation
3.5.3.8.: WHERE clause
3.5.3.9.: CONNECT BY clause
3.5.3.10.: GROUP BY clause
3.5.3.10.1.: GROUP BY columns
3.5.3.10.2.: GROUP BY column index
3.5.3.10.3.: GROUP BY tables
3.5.3.10.4.: GROUP BY ROLLUP
3.5.3.10.5.: GROUP BY CUBE
3.5.3.10.6.: GROUP BY GROUPING SETS
3.5.3.10.7.: GROUP BY empty grouping set
3.5.3.11.: HAVING clause
3.5.3.12.: WINDOW clauseWINDOW clause
3.5.3.13.: QUALIFY clause
3.5.3.14.: ORDER BY clause
3.5.3.14.1.: Ordering by field index
3.5.3.14.2.: Ordering and NULLS
3.5.3.14.3.: Ordering using CASE expressions
3.5.3.14.4.: Oracle's ORDER SIBLINGS BY clause
3.5.3.15.: LIMIT .. OFFSET clause
3.5.3.16.: WITH TIES clause
3.5.3.17.: SEEK clause
3.5.3.18.: FOR clause
3.5.3.19.: FOR UPDATE clause
3.5.3.20.: Set operations
3.5.3.20.1.: Type safety
3.5.3.20.2.: Projection rowtype
3.5.3.20.3.: Differences to standard SQL
3.5.3.20.4.: UNION
3.5.3.20.5.: INTERSECT
3.5.3.20.6.: EXCEPT
3.5.3.21.: Lexical and logical SELECT clause order
3.5.4.: The INSERT statement
3.5.4.1.: INSERT .. VALUES
3.5.4.2.: INSERT .. DEFAULT VALUES
3.5.4.3.: INSERT .. SET
3.5.4.4.: INSERT .. SELECT
3.5.4.5.: INSERT .. ON DUPLICATE KEY UPDATE
3.5.4.6.: INSERT .. ON DUPLICATE KEY UPDATE .. EXCLUDED
3.5.4.7.: INSERT .. ON DUPLICATE KEY UPDATE .. SET ALL TO EXCLUDED
3.5.4.8.: INSERT .. ON DUPLICATE KEY IGNORE
3.5.4.9.: INSERT .. ON CONFLICT .. EXCLUDED
3.5.4.10.: INSERT .. ON CONFLICT .. SET ALL TO EXCLUDED
3.5.4.11.: INSERT .. ON CONFLICT
3.5.4.12.: INSERT .. RETURNING
3.5.5.: The UPDATE statement
3.5.5.1.: UPDATE .. SET
3.5.5.2.: UPDATE .. SET ROW
3.5.5.3.: UPDATE .. FROM
3.5.5.4.: UPDATE .. WHERE
3.5.5.5.: UPDATE .. ORDER BY .. LIMIT
3.5.5.6.: UPDATE .. RETURNING
3.5.6.: The DELETE statement
3.5.6.1.: DELETE .. USING
3.5.6.2.: DELETE .. WHERE
3.5.6.3.: DELETE .. ORDER BY .. LIMIT
3.5.6.4.: UPDATE .. RETURNING
3.5.7.: The MERGE statement

previous : next

References to this page

Feedback

Do you have any feedback about this page? We'd love to hear it!

Tell us a little bit about yourself and join our newsletter (examples)

SQL Statements (DML)

Table of contents

References to this page

Feedback

Community

Support

Legal

Documentation