/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

22 votes125 views2 answers
Mysql show all tables
SQL
2 votes138 views1 answer
Sql server case sensitive search
SQL
3 votes132 views5 answers
Mysql get last inserted id
SQL
1 vote147 views2 answers
Postgresql remote connect
SQL
0 vote145 views1 answer
Postgresql not in alternative
SQL
-1 vote144 views2 answers
Postgresql get last 10 records
SQL
2 votes97 views1 answer
Sql group by different columns
SQL
0 vote145 views1 answer
How to run mysql in git bash
SQL
11 votes149 views3 answers
Change column name sql server management studio
SQL
0 vote154 views1 answer
Retornar apenas o ano mysql date
SQL