Available in versions: Dev (3.21) | Latest (3.20) | 3.19 | 3.18 | 3.17 | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11
SELECT clause
Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
The SELECT clause lets you project your own record types, referencing table fields, functions, arithmetic expressions, etc. The DSL type provides several methods for expressing a SELECT clause:
-- The SELECT clause SELECT BOOK.ID, BOOK.TITLE SELECT BOOK.ID, TRIM(BOOK.TITLE)
// Provide a varargs Fields list to the SELECT clause: Select<?> s1 = create.select(BOOK.ID, BOOK.TITLE); Select<?> s2 = create.select(BOOK.ID, trim(BOOK.TITLE));
The following sections illustrate various features and subclauses of the SELECT clause.
Table of contents
- 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
| previous : next |
References to this page
- Settings: implicit join type
- The SELECT statement
- Use SelectField types in the SELECT clause in jOOQ
- Using Table types as SelectField
- The implicit path JOIN notation for to-many joining
- The WINDOW clause of the SELECT statement
- Passing a field index to the ORDER BY clause
- Lexical and logical SELECT clause order
- Creating scalar functions
- How aggregate functions interact with GROUP BY
- Nested records
- Optional column expressions used for dynamic SQL
- Optional conditional expressions used for dynamic SQL
- QueryPart declaration vs reference
- GROUP BY <column index>
- Pattern based transformations: Unnecessary EXISTS subquery clauses
- The difference between Record and TableRecord
- Too Many Columns
- Don't do this in SQL: SELECT *
Feedback
Do you have any feedback about this page? We'd love to hear it!