/SQL/Sql select only row with the max date

Sql select only row with the max date

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;

Sql select only row with the max date

SELECT *
  FROM situation
 WHERE datevenement = (SELECT MAX(datevenement)
                         FROM situation
                        WHERE matricule = 12)
   AND matri = 12;

Similar codes

0 vote290 views1 answer
Oracle sql replace string in clob
SQL
2 votes338 views1 answer
Postgresql format date dd/mm/yyyy
SQL
-1 vote317 views2 answers
Sql query examples
SQL
0 vote389 views1 answer
Sql select without column name
SQL
0 vote355 views1 answer
Setval in postgres
SQL
0 vote409 views2 answers
Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.
SQL
0 vote389 views1 answer
Sql injection payload list github
SQL
1 vote378 views1 answer
Mysql previous year
SQL
0 vote364 views1 answer
Enable sql server full text indexing
SQL
0 vote349 views1 answer
Ran rails db:migrate and got == 20210620104415 DeviseCreateUsers: migrating ================================ -- create_table(:users) rails aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLE
SQL