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

6 votes185 views2 answers
Psql load dump
SQL
-2 votes194 views1 answer
No module named '_sqlite3
SQL
1 vote286 views1 answer
Adding a check statement in sql
SQL
3 votes181 views1 answer
Postgres count distinct
SQL
3 votes186 views2 answers
Sql select data from last week
SQL
11 votes215 views3 answers
Change column name sql server management studio
SQL
1 vote173 views1 answer
Sql trigger before delete
SQL
0 vote185 views1 answer
Import sql in postgresql
SQL
5 votes208 views3 answers
Select tables from mysql database
SQL
0 vote265 views1 answer
ORA-01400
SQL