Mysql min value row

SELECT t1.*
FROM employees t1
INNER JOIN (
    SELECT id, min(salary) AS salary FROM employees GROUP BY id
) t2 ON t1.id = t2.id AND t1.salary = t2.salary;

Similar codes

3 votes173 views5 answers
Import MySQLdb as Database ModuleNotFoundError: No module named 'MySQLdb'
SQL
21 votes194 views3 answers
Sql server search column name in all tables
SQL
0 vote166 views1 answer
C# check if mysql query modified rows
SQL
0 vote221 views1 answer
Create table with timestamp mysql youtube
SQL
2 votes170 views1 answer
Date conversion in mysql column
SQL
0 vote164 views1 answer
Create table if not exist with exceptions
SQL
0 vote164 views1 answer
Opensuse status MySQL
SQL
0 vote170 views2 answers
How to update the multiple rows in sql
SQL
0 vote171 views1 answer
Sqlite3 get data from table c
SQL
17 votes169 views6 answers
Current date in sql
SQL