Sql select min 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 vote347 views1 answer
Update using case in mysql
SQL
3 votes399 views1 answer
Postgres select max value
SQL
0 vote390 views1 answer
Show specific events on mysql
SQL
6 votes401 views3 answers
Psql show columns of table
SQL
1 vote345 views1 answer
Add sequence postgres
SQL
0 vote355 views1 answer
Sql developer sql worksheet not showing
SQL
0 vote362 views1 answer
Mysql regex select
SQL
3 votes343 views3 answers
How to set up an auto incrementing id db browser
SQL
4 votes387 views1 answer
List tables sqlite
SQL
0 vote355 views1 answer
Mysql beautifier terminla
SQL