/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 vote344 views1 answer
Postgres clear table
SQL
1 vote347 views1 answer
Retrieve meaning
SQL
0 vote314 views0 answer
SQL
0 vote291 views1 answer
Mysql convert column to uppercase
SQL
2 votes343 views1 answer
Laravel sql String
SQL
12 votes327 views4 answers
Install mysql ubuntu 18.04
SQL
0 vote321 views1 answer
How to fetch highest score in minimum time using mysql
SQL
0 vote303 views1 answer
Connection error in mysql workbench
SQL
0 vote353 views1 answer
Oracle for loop on list
SQL
1 vote340 views1 answer
Psql client write to bash variable
SQL