Sql select min 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 votes243 views1 answer
Scaffold npgsql net core
SQL
-1 vote233 views1 answer
How to switch user in mysql
SQL
0 vote242 views1 answer
Trigger stock phpmyadmin output message
SQL
0 vote222 views1 answer
Deny select insert update delete sql
SQL
3 votes238 views2 answers
Enter mysql command line
SQL
16 votes244 views3 answers
Tsql rename column name
SQL
0 vote243 views2 answers
Sqlalchemy core in clause
SQL
4 votes237 views2 answers
Postgres update single column
SQL
0 vote221 views1 answer
Get duplicate entry sql
SQL
37 votes225 views3 answers
Duplicate records in sql
SQL