Thanks for your message. I'll answer on Stack Overflow 2018-03-23 13:34 GMT+01:00 'James Cowan' via jOOQ User Group < [email protected]>:
> > 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. > -- 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.
