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 vote163 views1 answer
How to add session data into mysql database from button
SQL
0 vote183 views1 answer
Sql server get date of previous sunday
SQL
0 vote178 views1 answer
Like date sql server not working
SQL
0 vote163 views1 answer
Install package for sqlserver in asp.net core
SQL
15 votes186 views6 answers
Drop foreign key mysql
SQL
1 vote158 views1 answer
Funzioni plsql
SQL
0 vote170 views1 answer
Create database store
SQL
0 vote179 views2 answers
Mysql calcular idade
SQL
0 vote167 views1 answer
Select from another database
SQL
0 vote207 views1 answer
Tsql cte in a transaction
SQL