/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 vote133 views1 answer
Alter table engine mysql
SQL
7 votes124 views2 answers
Add column table pl sql
SQL
0 vote133 views1 answer
Mysql trim characters
SQL
4 votes155 views1 answer
Ms sql truncate table vs delete
SQL
-1 vote86 views1 answer
Oracle db list usernames
SQL
0 vote160 views1 answer
Offset in postgresql example
SQL
0 vote125 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
0 vote132 views1 answer
Mysql_num_fields in mysqli
SQL
0 vote144 views1 answer
Sql server insert inner join
SQL
0 vote145 views1 answer
Add mysql database to power bi web
SQL