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 vote137 views1 answer
Sql on-premises
SQL
0 vote127 views1 answer
Sql count * vs count 1
SQL
0 vote139 views1 answer
PGSQL dynamic table name
SQL
0 vote134 views1 answer
Exectuer myssql .sql
SQL
0 vote127 views1 answer
Greater than or equal to symbol in postgres
SQL
3 votes127 views3 answers
Create a view postgres
SQL
0 vote125 views1 answer
Create table if not exist with exceptions
SQL
0 vote140 views1 answer
Alter table change default
SQL
9 votes130 views2 answers
Nosql databases
SQL
1 vote143 views1 answer
How to put value in variable mysql
SQL