/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 vote340 views2 answers
Close external port 3306 with iptables
SQL
0 vote322 views1 answer
Mariadb LOAD DATA INFILE
SQL
0 vote406 views1 answer
Connect google bigquery connect using sqirrel
SQL
3 votes339 views2 answers
Sql random integer
SQL
2 votes403 views1 answer
Pdo mysql insert
SQL
0 vote407 views1 answer
Wordpress make wp user in db
SQL
1 vote360 views1 answer
Postgresql define pk sequence next number
SQL
1 vote371 views1 answer
Customer using hdfc bank sql query
SQL
32 votes434 views6 answers
Rename column mysql
SQL
0 vote306 views2 answers
How to combine two sql queries in one result
SQL