select count distinct from group

[James Cowan]

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

[Lukas Eder]

Thanks for your message. I'll answer on Stack Overflow

--
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 jooq-user+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.