/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

5 votes384 views1 answer
Sql integer to serial
SQL
0 vote386 views1 answer
Select year from dual oracle
SQL
10 votes381 views4 answers
Else if mysql
SQL
2 votes388 views1 answer
Create mysql user on all hosts
SQL
0 vote386 views1 answer
Dual in db2
SQL
1 vote363 views1 answer
Size of all tables in a schema oracle
SQL
0 vote358 views1 answer
Get enginge db mysql
SQL
0 vote315 views1 answer
How to get last client id sql
SQL
0 vote331 views1 answer
Sql roll up rows into columns
SQL
4 votes397 views3 answers
Sql find second highest salary employee
SQL