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 vote104 views1 answer
Drop all triggers oracle
SQL
0 vote121 views1 answer
Uncheck constraints and delete from table
SQL
0 vote113 views1 answer
Tsql table column constraint must be uppercase
SQL
0 vote132 views2 answers
Search stored procedures by name
SQL
0 vote101 views1 answer
What is between operator
SQL
0 vote113 views1 answer
Create a sql server database programmatically
SQL
0 vote92 views1 answer
Java input type sql date
SQL
0 vote104 views1 answer
Check psql validity function
SQL
0 vote120 views1 answer
How to get parent and child record in single query using sql
SQL
0 vote113 views1 answer
Php get closest location by latitude longitude
SQL