/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 vote236 views1 answer
Sql datediff db2
SQL
0 vote257 views1 answer
Psql initialization
SQL
0 vote249 views1 answer
Vs 2019 connect to local mysql database
SQL
1 vote239 views1 answer
Snowflake rename column name
SQL
0 vote248 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
1 vote231 views1 answer
Copy postgres table from one schema into another
SQL
5 votes243 views2 answers
Create table mysql example auto_increment
SQL
0 vote225 views1 answer
Replace sqlalchemy
SQL
0 vote232 views3 answers
Remove folders from remote git
SQL
3 votes219 views1 answer
Oracle revoke
SQL