/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 vote167 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
0 vote221 views5 answers
Select concat alter table mysql
SQL
-3 votes162 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL
0 vote173 views1 answer
Java nosql sort
SQL
0 vote198 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
8 votes220 views1 answer
Mysql dump restore
SQL
25 votes266 views6 answers
Change column name mysql
SQL
42 votes244 views6 answers
Sql query duplicate rows
SQL
0 vote166 views2 answers
Oracle create chain rule
SQL
0 vote270 views1 answer
Get statis values sql
SQL