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

0 vote271 views1 answer
Use where instead of join
SQL
0 vote250 views1 answer
Mysql date + 1 day
SQL
0 vote268 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
0 vote259 views1 answer
How to to get current date and time in sql
SQL
0 vote360 views1 answer
How to rename a database in tsql
SQL
54 votes450 views6 answers
Sql rename column
SQL
0 vote345 views1 answer
Sql '=' cannot be applied to date varchar(10) athena
SQL
0 vote310 views1 answer
Joomla execute raw sql
SQL
0 vote249 views8 answers
Convert sql query to linq online
SQL
4 votes281 views1 answer
Mysql not equal
SQL