/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 vote190 views1 answer
How to declare variable date in mysql
SQL
1 vote203 views3 answers
Rows, INSERT INTO
SQL
16 votes187 views4 answers
Sort by sql
SQL
4 votes189 views2 answers
Mysql select where starts with
SQL
0 vote193 views2 answers
Mysql get routine parameter list
SQL
0 vote185 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL
0 vote196 views1 answer
Mysql add to number
SQL
0 vote190 views1 answer
Get time component of datetime sql
SQL
4 votes219 views1 answer
Ms sql truncate table vs delete
SQL
0 vote185 views1 answer
Min and max salary and name in sql
SQL