Created
November 23, 2020 18:47
-
-
Save flash-gordon/7603b49a0d1a3b76559e04438ddbec81 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- users | |
select u.* | |
from users u | |
where u.id = 123 | |
order by u.id; | |
-- books | |
select count(*) as b_cnt, | |
b.user_id | |
from books b | |
group by b.user_id | |
order by b_cnt desc; | |
-- users.join(books).select_append(books[:b_cnt]) | |
select u.*, | |
b.b_cnt | |
from users u | |
inner join books b | |
on b.user_id = u.id | |
where u.id = 123 | |
group by b.user_id | |
order by u.id, b.b_cnt desc; | |
-- users.join(books).select_append(books[:b_cnt]) | |
select u.* | |
from users u | |
inner join ( | |
select count(*) as b_cnt, | |
b.user_id | |
from books b | |
group by b.user_id | |
order by b_cnt desc) b | |
on b.user_id = u.id | |
where u.id = 123 | |
order by u.id; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment