/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 votes123 views1 answer
Mysql load sql from file
SQL
13 votes123 views4 answers
Mysql select last 10 rows
SQL
0 vote134 views1 answer
Rows, INSERT INTO, Returning
SQL
5 votes146 views2 answers
Get columns number sql
SQL
0 vote122 views1 answer
How to convert DateTime to VarChar SQL
SQL
1 vote122 views1 answer
Loading local data is disabled mysql
SQL
0 vote163 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
0 vote132 views1 answer
Grant owner postgresql
SQL
14 votes142 views3 answers
Inner join sql oracle
SQL
0 vote122 views1 answer
Recover deleted data from mysql database
SQL