/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

12 votes152 views4 answers
Mysql version query
SQL
0 vote150 views1 answer
How to know if table in rigt or left in sql
SQL
14 votes159 views6 answers
Auto_increment mysql
SQL
0 vote175 views1 answer
How much space does sql server take per row
SQL
0 vote146 views1 answer
Lesser than or equal to symbol in postgres
SQL
0 vote155 views1 answer
Ksql quickstart docker
SQL
1 vote96 views1 answer
Insert into sql
SQL
2 votes156 views5 answers
Tablespace ORACLE
SQL
0 vote160 views1 answer
Get date ISO in psql
SQL
19 votes150 views5 answers
Change column name mysql command line
SQL