SQL和窗口功能JOOQ
问题描述:
我有这个疑问:SQL和窗口功能JOOQ
SELECT id, url, name, email, count(*) OVER() AS overallCount
FROM images
WHERE email = ?
OFFSET ?
LIMIT ?
我想将它翻译成JOOQ,我怎么能做到这一点?
答
假设这个静态导入
import static org.jooq.impl.DSL.*;
然后
String email = ...
int offset = ...
int limit = ...
using(configuration)
.select(
IMAGES.ID,
IMAGES.URL,
IMAGES.EMAIL,
count().over().as("overallCount"))
.from(IMAGES)
.where(IMAGES.EMAIL.eq(email))
.offset(offset)
.limit(limit)
.fetch();