/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 vote324 views1 answer
Generate random & unique mysql string
SQL
1 vote311 views1 answer
Sql into vs insert into
SQL
2 votes310 views2 answers
Sql first character
SQL
0 vote309 views1 answer
Mysql date format unix timestamp
SQL
-1 vote329 views5 answers
Not in sql
SQL
0 vote309 views1 answer
Python sqlalchemy orm to select null values
SQL
0 vote290 views1 answer
Grant access on table in oracle
SQL
1 vote311 views1 answer
Change old domain to new domain name wordpress
SQL
-1 vote300 views3 answers
Create temp table in sql
SQL
15 votes325 views4 answers
Mysql where value is null
SQL