3 ms·
It doesn't make sense to put two limit here, it's essential a single select query with join table. If you mean use sub-query. You may write something like belo
by aabbcc1241 4y ago
It doesn't make sense to put two limit here, it's essential a single select query with join table.
If you mean use sub-query. You may write something like below
select post [
id
title
user { nickname }
]
limit 5
where user_id in (
select user [ id ]
order by created_at desc
limit 2
)
Thanks for your interest, welcome more questions and ideas :)