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 vote328 views1 answer
Does insert into overwrite sql
SQL
0 vote319 views1 answer
Soql user profile
SQL
-1 vote351 views1 answer
Minus vs except in sql
SQL
0 vote348 views1 answer
Psql get table data types
SQL
1 vote344 views1 answer
Sql current timestamp
SQL
0 vote317 views1 answer
Get record which is available in one table but not in another mysql
SQL
0 vote357 views1 answer
Add super privilege mysql
SQL
0 vote300 views1 answer
Bigquery information_schema schema all columns
SQL
0 vote437 views1 answer
Php insert null mysql
SQL
9 votes343 views4 answers
How to alter table column name in mysql
SQL