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 vote207 views1 answer
Select other columns with distinct
SQL
13 votes245 views4 answers
Mysql remove foreign key constraint
SQL
0 vote232 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL
0 vote240 views2 answers
Mysql calcular idade
SQL
36 votes288 views6 answers
Change column data type sql
SQL
1 vote271 views1 answer
Oracle drop temporary table
SQL
0 vote255 views1 answer
Netstat -tln mysql
SQL
0 vote238 views1 answer
TSQL convert csv to table
SQL
4 votes180 views1 answer
And or sql order of operations
SQL
0 vote238 views2 answers
Advantages of stored procedures sql
SQL