/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

3 votes217 views1 answer
How to uninstall microsoft sql server
SQL
1 vote209 views1 answer
Delete mysql from mac
SQL
0 vote231 views1 answer
Migration graphql
SQL
0 vote269 views1 answer
Reset a table's identity column and remove test records
SQL
0 vote244 views1 answer
Consecutive numbers sql
SQL
1 vote201 views1 answer
Mysql select utc time in eastern time
SQL
9 votes207 views2 answers
Sql limit order by
SQL
1 vote216 views1 answer
Sqlite create index
SQL
1 vote224 views1 answer
Postgresql float 2 decimal places
SQL
0 vote228 views1 answer
MySQL update with subquery
SQL