0

I want to extract top 5 poster's email and its post count in my board application.

for example, this is my board table schema. | email | title | content |

And following SQL gives me every people's email who posted in my board and their post count.

SELECT email, COUNT(*) FROM myboard GROUP BY email ORDER BY COUNT(*) DESC;

|  email  | COUNT(*)|
---------------------
| a@a.com | 20      |
| b@a.com | 17      |
| c@a.com | 11      |
...

I want limit only top 5 poster. In MYSQL Limit 0, 5 works well, but Oracle does not have LIMIT query.

So how can i do it in the Oracle?

Knowledge Drilling
  • 986
  • 1
  • 8
  • 22

0 Answers0