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

2 votes302 views1 answer
Sql create database
SQL
0 vote327 views1 answer
Stored procedures example
SQL
2 votes354 views3 answers
How to replace null values in sql
SQL
0 vote306 views1 answer
Nosql vs sql
SQL
1 vote310 views1 answer
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
SQL
0 vote293 views1 answer
Mysql auto increment default value with prefix month and year
SQL
15 votes414 views5 answers
Select all tables sql
SQL
0 vote315 views1 answer
Exectuer myssql .sql
SQL
0 vote262 views1 answer
Count char in java
SQL
0 vote338 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL