/SQL/Sql select maximum column with other columns returned

Sql select maximum column with other columns returned

 with cte as 
 (
     select id, home, date , player, resource, 
     Row_Number()Over(Partition by home order by date desc) rownumber from TestTable
 )
 select id, home, date , player, resource from cte where rownumber=1

Source: stackoverflow.com

Similar codes

0 vote217 views1 answer
T-sql delete view if exists
SQL
0 vote173 views1 answer
Mysql join table with a text columns with ids splited by char
SQL
1 vote156 views1 answer
Get table which have specific columns in mysql
SQL
0 vote248 views1 answer
Database timezone
SQL
-1 vote145 views2 answers
On update cascade
SQL
0 vote169 views1 answer
Oracle execute immediate quotes
SQL
0 vote173 views1 answer
How to drop a trigger in postgresql
SQL
0 vote162 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
16 votes163 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
0 vote145 views1 answer
Mysql select where text contains
SQL