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 vote218 views2 answers
Clauses in mysql
SQL
0 vote291 views1 answer
Mysql grant access to one database
SQL
11 votes182 views2 answers
Mysql set safe mode off
SQL
0 vote229 views1 answer
How to subquey to do not load in live database in
SQL
0 vote196 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
11 votes193 views2 answers
Safe mode off mysql
SQL
4 votes181 views1 answer
Force drop all tables postgres
SQL
0 vote270 views2 answers
Disadvantages of stored procedures sql
SQL
2 votes190 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
1 vote201 views1 answer
Oracle drop job if exists
SQL