/SQL/Mysql select row with max value group by

Mysql select row with max value group by

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 vote281 views1 answer
Run mysql xampp shell
SQL
0 vote256 views1 answer
Oracle execute immediate quotes
SQL
1 vote279 views4 answers
Psql check tables command
SQL
1 vote287 views1 answer
Add many column to sap iq table
SQL
2 votes325 views1 answer
Sql compare strings
SQL
0 vote284 views1 answer
Close sql query vb.net
SQL
3 votes288 views1 answer
Postgresql if null then 0
SQL
0 vote298 views1 answer
Copy column from one table to another without column duplicate postgres
SQL
0 vote278 views1 answer
Null column as zero in mysql
SQL
0 vote274 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL