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 vote197 views3 answers
Sql server import json
SQL
0 vote150 views1 answer
Update sql join multiple tables
SQL
4 votes202 views2 answers
Postgre sql create table
SQL
8 votes182 views2 answers
Phpmyadmin password
SQL
0 vote201 views1 answer
Setval in postgres
SQL
0 vote206 views1 answer
Sp in sql server
SQL
0 vote244 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
0 vote194 views1 answer
Check duplicate values plsql
SQL
0 vote198 views1 answer
Postgres set default schema
SQL
0 vote202 views1 answer
Sql change column in existing table
SQL