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 vote423 views3 answers
Postgres trim string
SQL
1 vote361 views3 answers
Java.sql.sqlexception: access denied for user
SQL
0 vote344 views1 answer
Left join in codeigniter query builder
SQL
0 vote306 views1 answer
Now() -1 mysql
SQL
0 vote368 views1 answer
Group by max date
SQL
1 vote371 views1 answer
Store select query result in variable sql server
SQL
0 vote339 views1 answer
T-SQL Retry (deadlock)
SQL
0 vote350 views1 answer
Replace string in whole database mysql stackoverflow
SQL
1 vote381 views1 answer
Insert many to many sql
SQL
0 vote337 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL