How to enable "duplicate" strings in MySQL?

Question

MySQL

Let's say there is a query:
SELECT * FROM video GROUP BY rating
The problem is that if the rating is repeated, then only one row with this rating is returned.
I need everything :(

Answer 1

Replace GROUP BY with ORDER BY