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

34 votes379 views6 answers
Alter table add foreign key mysql
SQL
0 vote333 views1 answer
Sql date time query find
SQL
0 vote256 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
6 votes389 views2 answers
Install psql mac
SQL
0 vote324 views1 answer
Sql composite key
SQL
11 votes756 views4 answers
Reset identity column values in sql server
SQL
0 vote308 views1 answer
Postgresql create user roles
SQL
4 votes317 views3 answers
Drop Table Oracle
SQL
8 votes308 views1 answer
Database backup in mysql server recovery
SQL
0 vote296 views1 answer
MySQL error code 2068
SQL