/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 vote97 views1 answer
Sqlite3 now
SQL
3 votes108 views1 answer
Sql insert inserted id
SQL
0 vote99 views1 answer
Mysql where don't have string
SQL
0 vote60 views1 answer
Mysql find foreign key references
SQL
0 vote114 views2 answers
Dumping sql table
SQL
2 votes101 views1 answer
Plsql left() function
SQL
0 vote93 views1 answer
QCompleter con sql
SQL
5 votes94 views2 answers
Create table
SQL
-1 vote106 views1 answer
How to create foreign key in sql server management studio
SQL
0 vote110 views1 answer
How to find unique element in sql
SQL