Sql select lowest 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 vote113 views1 answer
Expression number 1 of select list is not in group by clause
SQL
0 vote118 views1 answer
Sqlite select split string
SQL
11 votes188 views1 answer
Oracle insert from select
SQL
1 vote116 views2 answers
Mysql join two tables
SQL
1 vote115 views1 answer
Mysql select row max date
SQL
3 votes107 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
0 vote125 views1 answer
SQL server datetime compare
SQL
0 vote108 views1 answer
Concat column value of same user in mysql
SQL
0 vote118 views1 answer
Python list from sql
SQL
0 vote117 views1 answer
Uncaught Error: Call to undefined function DatabaseOld\mysqli_connect()
SQL