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

7 votes238 views1 answer
Show line number in sql server
SQL
1 vote214 views1 answer
Change default maximum runtime mariadb from phpmyadmin
SQL
0 vote205 views1 answer
Oracle sql generate list of days
SQL
0 vote250 views1 answer
How to fetch data from database in sql
SQL
-1 vote194 views2 answers
Postgresql user permissions to database
SQL
1 vote208 views1 answer
Select not matching data from two tables
SQL
5 votes252 views3 answers
Sql limit offset
SQL
-1 vote289 views1 answer
Pl sql drop trigger
SQL
0 vote210 views1 answer
Sql server union if table exist
SQL
0 vote214 views1 answer
Interview experience as a call?
SQL