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

1 vote153 views1 answer
Mysql show attributes of a table
SQL
0 vote202 views1 answer
Mysql root localhost run
SQL
2 votes189 views1 answer
Mysql add boolean column
SQL
0 vote175 views2 answers
Mysql create table if not exists
SQL
2 votes173 views1 answer
Can you use a where clause for a child query
SQL
0 vote193 views1 answer
Select * from mysql.proc
SQL
0 vote191 views1 answer
Get last date join sql
SQL
22 votes182 views4 answers
Show list of users in mysql
SQL
3 votes199 views1 answer
Oracle apex message quit website
SQL
0 vote203 views1 answer
Django mssql backend
SQL