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 vote153 views3 answers
PS5
SQL
29 votes130 views6 answers
Delete all rows from table mysql
SQL
0 vote137 views1 answer
Subquery aggregation
SQL
2 votes144 views3 answers
Mysql list tables by size
SQL
0 vote137 views2 answers
Sql server select where date
SQL
0 vote168 views2 answers
Get value from a table an insert it with other values in another table sql
SQL
11 votes156 views3 answers
Sql line numbers
SQL
2 votes139 views2 answers
Mysql bidirectional composite primary key
SQL
1 vote146 views5 answers
What is in operator in sql
SQL
0 vote131 views1 answer
Update top 100 sql
SQL