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.

Table of contents

4.3.1.

jOOQ's DSL and model API

4.3.2.

The WITH clause

4.3.3.

The SELECT statement

4.3.3.1.

SELECT clause

4.3.3.2.

FROM clause

4.3.3.3.

JOIN operator

4.3.3.4.

WHERE clause

4.3.3.5.

CONNECT BY clause

4.3.3.6.

GROUP BY clause

4.3.3.7.

HAVING clause

4.3.3.8.

WINDOW clause

4.3.3.9.

ORDER BY clause

4.3.3.10.

LIMIT .. OFFSET clause

4.3.3.11.

SEEK clause

4.3.3.12.

FOR UPDATE clause

4.3.3.13.

UNION, INTERSECTION and EXCEPT

4.3.3.14.

Oracle-style hints

4.3.3.15.

Lexical and logical SELECT clause order

4.3.4.

The INSERT statement

4.3.5.

The UPDATE statement

4.3.6.

The DELETE statement

4.3.7.

The MERGE statement