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

31 votes264 views3 answers
Sql count
SQL
0 vote228 views0 answer
How to connect to datbase in springboot
SQL
0 vote276 views1 answer
Mysql change timestamp on update
SQL
5 votes303 views1 answer
Sql integer to serial
SQL
3 votes293 views1 answer
Oracle list dates without weekends
SQL
0 vote294 views1 answer
Php mysqli install
SQL
1 vote270 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception table not found
SQL
1 vote291 views1 answer
How to get previous year from sysdate in oracle
SQL
0 vote297 views1 answer
Savepoint mysql script
SQL
0 vote299 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL