/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 vote194 views1 answer
Join in update query in mysql
SQL
1 vote198 views1 answer
Create temporal table in sql
SQL
2 votes198 views2 answers
Mysql date range
SQL
0 vote220 views1 answer
Sql convert unix time to date
SQL
3 votes204 views1 answer
Oracle APEX elapsed time
SQL
0 vote200 views1 answer
Sql find table by name
SQL
0 vote196 views1 answer
Sql count * vs count 1
SQL
11 votes211 views1 answer
Ddl materialized view
SQL
0 vote204 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL
0 vote207 views1 answer
Plpgsql coalesce equivalent for empty string
SQL