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 votes197 views3 answers
Copy data from one table column to another table column in sql
SQL
0 vote184 views1 answer
Oracle sql developer closed connection
SQL
0 vote188 views1 answer
Object of class mysqli_result could not be converted to string
SQL
0 vote190 views1 answer
QUERY JPQL
SQL
5 votes177 views1 answer
Mysql change primary key
SQL
1 vote197 views1 answer
Sql select row with max date
SQL
1 vote181 views1 answer
Moodle query item quiz
SQL
1 vote243 views1 answer
Psql connect
SQL
0 vote195 views1 answer
How to get first 10 records of a table in mysql
SQL
0 vote183 views1 answer
Exclude last comma separated string mysql
SQL