Mysql min 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

-1 vote338 views1 answer
Io
SQL
0 vote366 views1 answer
Oracle activate program
SQL
6 votes344 views1 answer
What is where clause in sql
SQL
0 vote340 views1 answer
Postgresql import a database of gzip
SQL
1 vote350 views1 answer
How to group by month using sql server
SQL
20 votes391 views4 answers
How to find average in sql
SQL
0 vote321 views1 answer
How to count null values in sql
SQL
7 votes397 views2 answers
Sql remove duplicates based on column
SQL
0 vote364 views1 answer
Postgresql replace html tags from string
SQL
3 votes356 views2 answers
Oracle privileges users
SQL