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

0 vote166 views1 answer
Can we rollback deleted data in sql
SQL
0 vote189 views1 answer
T-SQL Create Trigger
SQL
0 vote245 views1 answer
Get last inserted primary key
SQL
0 vote179 views1 answer
Search column name sql
SQL
1 vote178 views2 answers
Mysql between
SQL
3 votes219 views2 answers
Enter mysql command line
SQL
1 vote205 views2 answers
Sql now - 1 day
SQL
0 vote166 views1 answer
Min mysql
SQL
18 votes167 views6 answers
Create table mysql
SQL
0 vote230 views1 answer
How to rename a database in tsql
SQL