How to formulate a request?

Question

MySQL

Two columns

1;21
1;45
1;23
2;34
2;23
3;52
3;52
3;13
3;26

How to keep only the smallest values ​​of the second column for each unique value of the first column?

That is

1;21
2;23
3;13

Answer 1

SELECT 
    field1,
    MIN(field2)
FROM tableName
GROUP BY 1