/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

6 votes188 views5 answers
Alter table oracle
SQL
0 vote210 views1 answer
Import excel to sql
SQL
0 vote198 views1 answer
Copying query result to excel
SQL
0 vote198 views1 answer
Sql offfset
SQL
2 votes312 views2 answers
How to DROP a table in mysql
SQL
4 votes202 views1 answer
Update table from another table oracle
SQL
0 vote193 views1 answer
Sqlite select split string
SQL
1 vote197 views1 answer
Ef core 5.0 usesqlserver not found
SQL
1 vote223 views2 answers
Sql queries practice
SQL
0 vote205 views1 answer
GROUP BY postgres
SQL