Mysql min 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 vote129 views1 answer
Sql express database size limit
SQL
0 vote146 views1 answer
SELECT statement to find the specific cell in database table
SQL
21 votes98 views7 answers
Table drop if exist sql server
SQL
0 vote186 views2 answers
Mysql cast to varchar
SQL
0 vote127 views1 answer
Sql roll up rows into columns
SQL
0 vote123 views1 answer
Strat with in sql
SQL
4 votes150 views1 answer
Select first and last row sql
SQL
0 vote170 views1 answer
Display all node label neo4j
SQL
19 votes132 views6 answers
Sql drop table if exists
SQL
0 vote125 views1 answer
Oracle index hint
SQL