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

1 vote122 views1 answer
How to get the date diff on once field in sql server
SQL
1 vote143 views2 answers
Remove space in mysql
SQL
2 votes134 views1 answer
Create delete procedure mysql
SQL
-1 vote128 views1 answer
Auto increment psql not primary key
SQL
25 votes146 views1 answer
How to update an attribute in MySQL
SQL
0 vote141 views1 answer
Sql query inline if
SQL
0 vote141 views1 answer
Mysql remove bad character from all fields
SQL
0 vote112 views1 answer
Call function sql oracle
SQL
0 vote147 views1 answer
Generate random & unique mysql string
SQL
9 votes121 views3 answers
Mysql show table column full description
SQL