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

0 vote337 views1 answer
SQL Server rename foreign key constraint
SQL
1 vote345 views2 answers
How to combine 2 tables in MySQL
SQL
0 vote355 views1 answer
Sql missing values
SQL
0 vote328 views1 answer
Can't connect to postgresql mac os
SQL
1 vote370 views1 answer
Mysql view curren querys
SQL
1 vote327 views2 answers
ImportError: No module named mysql.connector
SQL
1 vote325 views1 answer
Sql server get users
SQL
1 vote357 views1 answer
Table valued functions in sql
SQL
2 votes381 views1 answer
Datefromparts mssql
SQL
11 votes386 views2 answers
Import mysql dump command line windows
SQL