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

2 votes150 views2 answers
Select list is not in group by clause
SQL
0 vote140 views1 answer
Object Information
SQL
0 vote143 views1 answer
RowDataPacket
SQL
0 vote155 views4 answers
Best data type to represent money in mysql
SQL
0 vote133 views1 answer
Using GROUP BY in MySQL Join Table
SQL
5 votes134 views1 answer
Mysql get last day of month
SQL
0 vote165 views1 answer
Query builder doctrien return sql
SQL
0 vote157 views1 answer
Mysqldump don't drop table
SQL
1 vote153 views3 answers
Remove unique key from a table
SQL
0 vote146 views2 answers
Nosqlbooster query other collection
SQL