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

0 vote206 views1 answer
Add unique constraint sql server multiple columns
SQL
0 vote199 views1 answer
Python sql last insertend
SQL
0 vote225 views1 answer
How to run mysql on terminal mac
SQL
2 votes162 views5 answers
Alter table primary key postgresql
SQL
0 vote212 views1 answer
Primary key multiple
SQL
19 votes211 views6 answers
Mysql if null
SQL
1 vote165 views1 answer
Postgresql last element of array
SQL
6 votes203 views1 answer
Oracle list primary key
SQL
0 vote254 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL
0 vote233 views1 answer
No suitable driver found for sqlite
SQL