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

2 votes140 views1 answer
Find all triggers in database
SQL
0 vote135 views1 answer
Change data type in mysql
SQL
6 votes147 views2 answers
Psql load dump
SQL
2 votes155 views1 answer
Sql get the name of user pc
SQL
13 votes160 views1 answer
Sql join 3 tables on id
SQL
0 vote133 views2 answers
Azure sql-datenbank
SQL
0 vote131 views1 answer
Truncate table sql server foreign key
SQL
0 vote148 views1 answer
Date on SQL
SQL
13 votes164 views2 answers
Sqlite rename table
SQL
1 vote151 views1 answer
Oracle drop temporary table
SQL