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

12 votes177 views3 answers
Install sqlite driver ubuntu
SQL
0 vote189 views1 answer
Sql missing values
SQL
0 vote176 views1 answer
Mysql isshow
SQL
0 vote266 views1 answer
Mysql loop through databases and execute query
SQL
17 votes180 views6 answers
Mysql import sql file
SQL
0 vote201 views1 answer
Createdb with postgresql on ubuntu
SQL
0 vote183 views1 answer
Find all tables where column name exists oracle
SQL
17 votes191 views3 answers
How to change a collumn name in sql
SQL
0 vote196 views1 answer
Phpmyadmin mysql conflict
SQL
0 vote173 views1 answer
VSCode SQL Server Connection error
SQL