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

15 votes112 views4 answers
T-sql drop function if exists
SQL
0 vote132 views1 answer
Postgresql using reserved word as column name
SQL
0 vote130 views1 answer
Get record which is available in one table but not in another mysql
SQL
32 votes133 views6 answers
Sql count where
SQL
0 vote110 views1 answer
Clear query cache sql server
SQL
3 votes247 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
0 vote129 views1 answer
Get foreign table names mysql
SQL
0 vote130 views1 answer
Supprimer les valeur d'une table mysql
SQL
3 votes150 views1 answer
Set default today mysql
SQL
3 votes130 views1 answer
Oracle drop user
SQL