質問編集履歴
1
他のやり方
title
CHANGED
File without changes
|
body
CHANGED
@@ -3,5 +3,6 @@
|
|
3
3
|
```SQL
|
4
4
|
SELECT * FROM post INNER JOIN (SELECT COUNT("favorites"."post_id") AS count_post_id, post_id AS post_id FROM "favorites" GROUP BY "favorites"."post_id") AS ranks ON post.id = ranks.post_id ORDER BY ranks.count_post_id DESC
|
5
5
|
```
|
6
|
+
また、他のやり方がありましたら、その方法も教えてください!
|
6
7
|
どなたかご存知でしたら、ご教示ください!
|
7
8
|
よろしくお願いいたします!
|