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

3 votes146 views1 answer
Oracle list user grants
SQL
0 vote162 views1 answer
Postgresql check total storage
SQL
4 votes157 views4 answers
Start mysql
SQL
0 vote158 views1 answer
Procedures sql insert mysql
SQL
0 vote143 views3 answers
Sql count condition
SQL
0 vote190 views1 answer
Sql anywhere create procedure
SQL
4 votes156 views1 answer
Phone number sql
SQL
1 vote161 views1 answer
Sql into vs insert into
SQL
0 vote184 views1 answer
How to subquey to do not load in live database in
SQL
7 votes150 views4 answers
Lowest salary in sql
SQL