Hi I posted this question on stackoverflow before I realises there was a JOOQ google group
https://stackoverflow.com/questions/49449495/jooq-select-count-distinct-from-group How do would turn this sql SELECT DISTINCT COUNT(*) OVER () AS TotalRecords FROM table GROUP BY column into a JOOQ query? This is how I would do a simple count query in JOOQ: Record record = jooq.select( TABLE.COLUMN.count() ).from( TABLE).fetchOne(); return record.into( Long.class ); Is it possible to express the "DISTINCT COUNT(*) OVER () AS TotalRecords" in JOOQ syntax? James -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
