/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

5 votes236 views3 answers
Truncate function in sql oracle
SQL
0 vote265 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
2 votes285 views1 answer
Coalesce sql
SQL
0 vote257 views1 answer
Difference between db.query and db.execute
SQL
0 vote256 views1 answer
Sql count more than 1
SQL
3 votes245 views1 answer
Oracle user quota unlimited
SQL
1 vote269 views1 answer
Postgres set sequence value to max id
SQL
0 vote262 views1 answer
Case when with count and combining similar values in sql
SQL
3 votes266 views1 answer
Postgres kill running query
SQL
0 vote254 views1 answer
Last date for each user sql
SQL