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 vote314 views1 answer
Nested if in mysql
SQL
12 votes337 views2 answers
Update column data type postgres
SQL
6 votes331 views2 answers
Database url postgres
SQL
0 vote375 views1 answer
How to get button for every record from mysql
SQL
0 vote354 views1 answer
Drop database using terminal postgres
SQL
7 votes350 views3 answers
Foreign key oracle
SQL
1 vote362 views1 answer
Mamp mysql path mac
SQL
4 votes328 views3 answers
Postgres set default value
SQL
9 votes311 views2 answers
Default number in sql
SQL
0 vote324 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL