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

0 vote183 views1 answer
How to create an SQL save method in ruby
SQL
5 votes286 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL
1 vote326 views1 answer
Adding a check statement in sql
SQL
0 vote207 views1 answer
Oracle gather table statistics
SQL
0 vote202 views1 answer
Mysql date only no time
SQL
2 votes190 views2 answers
Mysql on duplicate key ignore
SQL
0 vote205 views1 answer
Postgresql copy backup table
SQL
1 vote222 views1 answer
Sql server get users
SQL
0 vote199 views1 answer
Will graphql replace sql
SQL
0 vote290 views1 answer
Do you know sql
SQL