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 vote252 views1 answer
Mysql show foreign keys column
SQL
0 vote295 views1 answer
Java sql timestamp now
SQL
0 vote255 views1 answer
Check if table exists oracle
SQL
0 vote257 views1 answer
Sql transact create cursor with dynamic tables
SQL
0 vote269 views3 answers
Postgresql grant alter table to user
SQL
2 votes260 views1 answer
Oracle sql day of month from date
SQL
1 vote263 views1 answer
Oracle sql create view
SQL
2 votes285 views2 answers
Mysql count rows returned
SQL
0 vote271 views1 answer
Postgres foreign key multiple columns
SQL
0 vote267 views2 answers
Sqlalchemy core in clause
SQL