/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

10 votes324 views4 answers
Join with multiple conditions sql
SQL
0 vote334 views1 answer
Mysql start of today
SQL
18 votes338 views3 answers
Mysql add column with default value
SQL
0 vote315 views1 answer
How to populate a table in MySQL from and existing csv file
SQL
6 votes336 views2 answers
Where clause in sql
SQL
4 votes331 views2 answers
Show all database inside postgresql
SQL
0 vote342 views2 answers
Functions with parameters SQL
SQL
0 vote322 views1 answer
Except in sql alchemy
SQL
-1 vote360 views1 answer
Pl sql drop trigger
SQL
1 vote338 views1 answer
Alphabetical order mysql
SQL