/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 vote256 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
0 vote252 views1 answer
Grant access on table in oracle
SQL
0 vote256 views1 answer
Insert thai language sql server
SQL
4 votes338 views2 answers
Delete all table oracle
SQL
0 vote285 views1 answer
Faire une recherche par liste de mot clé sql
SQL
1 vote273 views1 answer
Postgres killing connections on db
SQL
0 vote281 views1 answer
Select sql in descending order
SQL
0 vote269 views1 answer
How change the field place in mysql
SQL
0 vote269 views1 answer
Postgres create extension if not exists
SQL
0 vote257 views1 answer
Table values functions in SQL
SQL