/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 vote301 views3 answers
Sql union
SQL
0 vote288 views1 answer
Find usage of table in sql server
SQL
0 vote274 views2 answers
Sql if empty then
SQL
3 votes283 views3 answers
Create a view postgres
SQL
0 vote226 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote275 views1 answer
How to check the port of mysql installation in mac
SQL
3 votes276 views1 answer
Force using index oracle
SQL
0 vote279 views2 answers
How to list all values of a column that start with a letter in sql
SQL
8 votes293 views3 answers
Connect python to mysql
SQL
0 vote320 views1 answer
Drop a view in sqlite
SQL