prepostsql 可以这样根据多个字段查询过滤唯一值,并且找到所有的对象赋值
select distinct on (b.tenant_id,b.user_id) b.* from billing_detail as b
对应的spring jpa的写法
@Query(value="select distinct on (b.tenant_id,b.user_id) b.* from billing_detail as b", nativeQuery = true)
fun findAllTenantIdsAndUserId(): List<BillingDetail>