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

1 vote287 views1 answer
How to select multiple columns from different tables in mysql
SQL
-1 vote243 views1 answer
Plsql while
SQL
0 vote293 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
0 vote298 views1 answer
Querry mysql by 2 columns
SQL
1 vote273 views1 answer
Media sql
SQL
1 vote291 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
0 vote281 views2 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'world.admin_tasks' doesn't exist
SQL
0 vote264 views1 answer
Mysql:5.6 syntax create table
SQL
0 vote313 views1 answer
Add new column in sql with foreign key
SQL
0 vote260 views1 answer
Postgresql create table default value timestamp
SQL