/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 vote178 views1 answer
Sql "List the contact methods found in the Contact table.For each contact method, list how many people chose that contact method."
SQL
0 vote176 views1 answer
Select STR_TO_DATE(date_seance1,'DD-MM-YYYY')
SQL
0 vote186 views1 answer
Oracle array
SQL
0 vote186 views1 answer
Plpgsql raise notice
SQL
49 votes286 views6 answers
Mysql add column to table
SQL
1 vote192 views2 answers
Mysql switch case
SQL
1 vote183 views1 answer
Mysql show queries running
SQL
0 vote191 views1 answer
How to populate a table in MySQL from and existing csv file
SQL
0 vote349 views1 answer
Mysql workbench Error Code: 2013. Lost connection to MySQL server during query
SQL
0 vote172 views1 answer
Mysql sql select one day before
SQL