/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 vote249 views1 answer
Change database name psql 8
SQL
2 votes218 views1 answer
Drop table if exists in postgres
SQL
1 vote231 views1 answer
Oracle update with sequence
SQL
1 vote204 views1 answer
Mysql collation
SQL
13 votes236 views5 answers
Select last row mysql
SQL
1 vote248 views1 answer
OstgreSQL version
SQL
1 vote181 views1 answer
File /etc/init.d/mysql not exists
SQL
5 votes245 views1 answer
Mysql last day of next month
SQL
0 vote255 views1 answer
How to make case insensitive in sql
SQL
0 vote262 views1 answer
PostgreSQL types and C# types
SQL