/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

2 votes252 views1 answer
Oracle trace session
SQL
2 votes207 views3 answers
Sql truncate table
SQL
0 vote194 views1 answer
Mysql cli output to a file
SQL
1 vote396 views1 answer
Postgres convert text to number
SQL
62 votes508 views8 answers
Mysql add column
SQL
1 vote245 views1 answer
Mysql return text after a final full stop
SQL
0 vote210 views1 answer
Get the Db column names from a SqlDataReader
SQL
2 votes217 views2 answers
Sqlalchemy return id after insert
SQL
0 vote195 views1 answer
Mysql default timestamp value to be current timestamp
SQL
2 votes150 views1 answer
Sql select in list
SQL