/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 vote125 views1 answer
Mysql regex select
SQL
0 vote127 views1 answer
Sql log file inof
SQL
0 vote120 views1 answer
Stored procedures example
SQL
11 votes122 views1 answer
Sql insert multiple rows from select
SQL
1 vote119 views1 answer
Sql server kill all connections
SQL
0 vote120 views1 answer
Mysql preg replace
SQL
0 vote141 views1 answer
Mysql bind-address default value
SQL
0 vote148 views1 answer
Sql int vs integer
SQL
0 vote71 views1 answer
Mysql insert with foreign key
SQL
1 vote130 views1 answer
How to subtract from the value of a table in sql
SQL