Group by max date

SELECT train, dest, time FROM ( 
  SELECT train, dest, time, 
    RANK() OVER (PARTITION BY train ORDER BY time DESC) dest_rank
    FROM traintable
  ) where dest_rank = 1

Source: stackoverflow.com

Similar codes

1 vote166 views1 answer
Postgres select as csv
SQL
1 vote193 views1 answer
Mysql select all and rename one
SQL
0 vote183 views1 answer
Where date major today mysql
SQL
0 vote185 views1 answer
Insert value in identity
SQL
0 vote161 views1 answer
Flask sqlalchemy update row
SQL
0 vote182 views1 answer
Datagrip execute procedure
SQL
0 vote174 views1 answer
Vbscript clean up ADODB.Recordset
SQL
0 vote174 views1 answer
What is logical database schema
SQL
7 votes176 views3 answers
Restore postgres database from sql file
SQL
0 vote175 views2 answers
Mysql two column combination unique
SQL