/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 vote319 views1 answer
Postgresql datetrunc too slow
SQL
18 votes314 views6 answers
Laravel form validation
SQL
23 votes355 views5 answers
Sql substring
SQL
0 vote366 views1 answer
What is metadata in sql
SQL
1 vote299 views1 answer
Primary key reset in SQL database
SQL
12 votes347 views5 answers
Rename table in mysql
SQL
0 vote323 views1 answer
Implicit inner join table alias
SQL
0 vote296 views1 answer
Raiserror nowait sql server
SQL
3 votes354 views3 answers
Create table in SQL Server
SQL
7 votes339 views5 answers
Oracle alter table
SQL