/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 vote219 views3 answers
Postgresql connect to database
SQL
2 votes184 views1 answer
Oracle sql drop table purge
SQL
-1 vote148 views2 answers
Datetime sql server week
SQL
0 vote229 views1 answer
Reindex mssql table
SQL
1 vote218 views1 answer
PL SQL MODIFY COLUMN NME
SQL
1 vote193 views1 answer
How to start with sql
SQL
1 vote212 views2 answers
Mysql switch case
SQL
0 vote190 views1 answer
SQL Server format datetime
SQL
10 votes207 views2 answers
Sql rtrim
SQL
0 vote261 views1 answer
Zsh: command not found: mysql mamp
SQL