how to get max version in SQL

get_max_version.sql

/**
MariaDB [temp]> select * from file;
+------+---------+
| id   | version |
+------+---------+
|    1 |      10 |
|    1 |      11 |
|    1 |      12 |
|    2 |      10 |
|    2 |      11 |
+------+---------+

**/

MariaDB [temp]> select id as id, version from file as f \
  where version = ( select version from file where id=f.id order by version desc limit 1 );
  
+------+---------+
| id   | version |
+------+---------+
|    1 |      12 |
|    2 |      11 |
+------+---------+