/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

1 vote128 views1 answer
Alter table column size oracle
SQL
1 vote116 views1 answer
Sql server 2016 reseed identity
SQL
14 votes139 views3 answers
SQL trim
SQL
0 vote142 views1 answer
Mysql get first 2 characters of string
SQL
2 votes92 views1 answer
Sql group by different columns
SQL
0 vote130 views1 answer
Sqlalchemy.exc.OperationalError:
SQL
0 vote131 views1 answer
Oracle list dblink
SQL
1 vote125 views1 answer
How to between in sql
SQL
0 vote149 views1 answer
Using distinct and count together in sql
SQL
17 votes125 views4 answers
Show tables sql server
SQL