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 vote197 views1 answer
Postgres reorder columns
SQL
0 vote193 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
25 votes289 views6 answers
Change column name mysql
SQL
0 vote254 views1 answer
BigQuery Remove Duplicate Keys From Table
SQL
3 votes194 views1 answer
Oracle revoke
SQL
3 votes204 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
0 vote198 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
9 votes198 views3 answers
Find all tables with column name
SQL
0 vote173 views1 answer
How to connect pgadmin with excel
SQL
4 votes211 views1 answer
Ms sql truncate table vs delete
SQL