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

4 votes313 views1 answer
Wilayah indonesia database
SQL
0 vote330 views1 answer
Postgres copy command
SQL
53 votes651 views6 answers
How to install mysql ubuntu
SQL
0 vote362 views1 answer
SQL-Arten
SQL
9 votes370 views3 answers
Find all tables with column name
SQL
3 votes307 views1 answer
System.debug apex
SQL
0 vote533 views2 answers
Create new table from existing table with data in sql server
SQL
5 votes337 views1 answer
How to use rank function in sql
SQL
7 votes345 views3 answers
Select latest entry in sql table
SQL
0 vote380 views1 answer
Mysql relationships between tables
SQL