更新时间:2023-02-26 10:19:18
这应该可以解决问题:
select distinct on (api_user.id) api_user.id,api_booking.install_ts
from api_booking inner
join api_user on api_booking.user_id=api_user.id
and api_booking.status='completed'
order by api_user.id,api_booking.install_ts
limit 20 ;