Sql select whole row max column

SELECT t1.*
FROM employees t1
INNER JOIN (
    SELECT id, max(salary) AS salary FROM employees GROUP BY id
) t2 ON t1.id = t2.id AND t1.salary = t2.salary;

Similar codes

0 vote126 views2 answers
Mysql decimal remove trailing zeros
SQL
0 vote114 views1 answer
Where date in datetime mysql
SQL
0 vote119 views2 answers
Jsonb
SQL
0 vote123 views1 answer
Mysql listing get a particu particular user firsdt
SQL
0 vote125 views2 answers
Py sqlite if entry exists
SQL
1 vote114 views1 answer
Mysql data from file
SQL
0 vote137 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
7 votes133 views2 answers
Where keyword sql
SQL
0 vote115 views1 answer
T-SQL Create Trigger
SQL
1 vote120 views1 answer
$query = mysqli_query($con, $sql); while ($row = mysqli_fetch_array($query))
SQL