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 vote114 views1 answer
Sql insert tuple
SQL
0 vote119 views1 answer
Data structures in sql
SQL
2 votes131 views1 answer
Mysql change data type of column
SQL
0 vote123 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL
0 vote140 views2 answers
Wordpress change url after migration mysql query
SQL
0 vote93 views2 answers
Influxdb delete measurement based on date
SQL
7 votes115 views1 answer
Grant schema permissions postgres
SQL
0 vote184 views1 answer
Oracle convert int to date
SQL
1 vote115 views1 answer
Display total number of tables in mysql
SQL
0 vote113 views1 answer
Insert thai language sql server
SQL