/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

3 votes143 views4 answers
Show columns from table
SQL
0 vote174 views1 answer
Sum values by month mariadb
SQL
0 vote180 views2 answers
Replace null with 0 in sql
SQL
0 vote162 views1 answer
Update set with join pl sql
SQL
0 vote176 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
0 vote178 views1 answer
Sql server count all tables rows
SQL
3 votes191 views1 answer
Select database in sql
SQL
8 votes196 views1 answer
Oracle search text in all packages
SQL
0 vote173 views1 answer
How to combine rows in sql server procedure
SQL
0 vote197 views1 answer
Sql cursor example multiple columns
SQL