Sql select row with max date

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

Similar codes

0 vote130 views1 answer
Sql server beginning of month
SQL
5 votes158 views3 answers
Create function in postgresql
SQL
0 vote118 views1 answer
How to select all fieldsin a soql query
SQL
9 votes143 views3 answers
Where clause sql
SQL
2 votes122 views1 answer
Q operator in plsql
SQL
2 votes123 views3 answers
Write sql query to find the second highest salary of employee
SQL
0 vote139 views1 answer
Define a variable in mysql from select
SQL
0 vote112 views1 answer
How to execute stored output to csv files
SQL
2 votes196 views1 answer
Postgresql group by month and year
SQL
0 vote125 views1 answer
Sql "List the contact methods found in the Contact table.For each contact method, list how many people chose that contact method."
SQL