/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

0 vote252 views1 answer
Provera dupliranih konatakata
SQL
1 vote275 views1 answer
What is int in mysql
SQL
1 vote265 views1 answer
Xampp import sql file command line
SQL
0 vote271 views1 answer
Mysql config slave
SQL
2 votes270 views1 answer
Sql get the name of user pc
SQL
2 votes280 views1 answer
Guid to string sql
SQL
2 votes298 views3 answers
Mysql kill
SQL
0 vote275 views1 answer
Interview experience as a call?
SQL
0 vote279 views2 answers
How covert into int in maria db
SQL
0 vote269 views1 answer
Drop all tables db2
SQL