count distinct
w3resource
SQL 语句
SELECT
count( DISTINCT `b2c_return_order`.`order_sn` )
FROM
`b2c_return_order`
WHERE
( `b2c_return_order`.`user_id` = 198 AND `b2c_return_order`.`refund_status` = 5 )
对应的JOOQ
int count = db().select(DSL.countDistinct(TABLE.ORDER_SN))
.from(TABLE)
.where