|The jOOQ User Manual. Multiple Pages : SQL building : Conditional expressions : BETWEEN predicate (degree > 1)||previous : next|
[A] BETWEEN [B] AND [C] [A] BETWEEN SYMMETRIC [B] AND [C]
[A] >= [B] AND [A] <= [C] ([A] >= [B] AND [A] <= [C]) OR ([A] >= [C] AND [A] <= [B])
The above can be factored out according to the rules listed in the manual's section about row value expression comparison predicates.
jOOQ supports the
BETWEEN [SYMMETRIC] predicate and emulates it in all SQL dialects where necessary. An example is given here:
row(BOOK.ID, BOOK.TITLE).between(1, "A").and(10, "Z");